home *** CD-ROM | disk | FTP | other *** search
/ Freelog 125 / Freelog_MarsAvril2015_No125.iso / ViePratique / Merops / setup.exe / {app} / Merops,1.xdm < prev    next >
Text File  |  2014-12-16  |  58KB  |  2,117 lines

  1. ###TABLE_STRUCT_ABONNEMENT
  2. DATE_FIN_ABONNEMENT VARCHAR(255)
  3. ###TABLE_DATA_ABONNEMENT
  4. REGISTRY_ROOT=HKEY_CURRENT_USER/SOFTWARE/{ID_SERV};REGISTRY_KEY1=FLUX(DATE);REGISTRY_KEY2=ADVANCED(BIT);HIDE_KEY=ONSTART_WINDOWS_SERVICE{ID_SERV=NETMAN}else{ID_SERV+1};KEY_CRYPT=PWD-678905{MD5}|
  5. ###TABLE_STRUCT_ALERTE
  6. CODE VARCHAR(20)
  7. ALERT_MIN CURRENCY
  8. ALERT_MAX CURRENCY
  9. PLACE VARCHAR(5)
  10. ALERT_SUIVEUR CURRENCY
  11. ###TABLE_DATA_ALERTE
  12. ###TABLE_STRUCT_DEVISE
  13. CODE VARCHAR(20)
  14. NOM VARCHAR(255)
  15. DATE_COURS DATETIME
  16. VARIATION CURRENCY
  17. PRIX_COURS CURRENCY
  18. PRIX_OPEN CURRENCY
  19. PRIX_BAS CURRENCY
  20. PRIX_HAUT CURRENCY
  21. PLACE VARCHAR(5)
  22. ID_DEVISE INTEGER AUTO_INCREMENT='100'
  23. ISO VARCHAR(3)
  24. SIGLE VARCHAR(10)
  25. ###TABLE_DATA_DEVISE
  26. QS0010040911|Dollar US||0|1.1231|0|0|0|p|1|USD|$|
  27. GB0003024162|Livre Sterling||0|0.6976|0|0|0|p|2|GBP|ú|
  28. CH0002748082|Franc Suisse||0|1.5376|0|0|0|p|3|CHF|FS|
  29. QS0010041018|Yen||0|136.495|0|0|0|p|4|JPY|Y|
  30. ABC000000016|Dollar Canadien||0|1.6022|0|0|0|p|8|CAD|CAD|
  31. ABC000000015|Dollar Australien||0|1.6941|0|0|0|p|9|AUD|AUD|
  32. ABC000000021|Dollar NΘo-zΘlandais||0|1.9766|0|0|0|p|10|NZD|NZD|
  33. ABC000000018|Couronne Danoise||0|7.4602|0|0|0|p|11|DKK|DKK|
  34. ABC000000020|Couronne NorvΘgienne||0|7.941|0|0|0|p|12|NOK|NOK|
  35. ABC000000023|Couronne SuΘdoise||0|9.3622|0|0|0|p|13|SEK|SEK|
  36. ###TABLE_STRUCT_FORUM
  37. ID_USER INTEGER
  38. NOM VARCHAR(50)
  39. PRENOM VARCHAR(50)
  40. PSEUDO VARCHAR(50)
  41. EMAIL VARCHAR(50)
  42. PASSWORD VARCHAR(10)
  43. PASSWORD_CRYPT VARCHAR(20)
  44. USER_CRYPT DATE
  45. PRO_CRYPT VARCHAR(20)
  46. SEND_MAIL BIT
  47. FORMAT_MAIL INTEGER
  48. RELEVE_HOST VARCHAR(200)
  49. RELEVE_PORT INTEGER
  50. RELEVE_USER VARCHAR(50)
  51. RELEVE_PWD VARCHAR(50)
  52. RELEVE_DIR VARCHAR(50)
  53. RELEVE_URL VARCHAR(200)
  54. RELEVE_CLE VARCHAR(50)
  55. RELEVE_IMG VARCHAR(50)
  56. RELEVE_CONTACT VARCHAR(200)
  57. RELEVE_NB INTEGER
  58. MAIL_OBJET VARCHAR(200)
  59. MAIL_CORPS VARCHAR(10000)
  60. MAIL_IS_TEST BIT
  61. MAIL_IS_CC BIT
  62. MAIL_TEST VARCHAR(50)
  63. MAIL_IS_HTML BIT
  64. RELEVE_FREQUENCE INTEGER
  65. RELEVE_COLONNE_PTF INTEGER
  66. RELEVE_DOM BIT
  67. RELEVE_OK_ONLY BIT
  68. RELEVE_SEARCH VARCHAR(20)
  69. RELEVE_SAVE VARCHAR(255)
  70. USER_CRYPT2 DATE
  71. PASSWORD_CRYPT2 VARCHAR(20)
  72. ###TABLE_DATA_FORUM
  73. ###TABLE_STRUCT_HISTORIQUE
  74. ID_ORIGINE SMALLINT
  75. ID INTEGER AUTO_INCREMENT='2'
  76. CODE VARCHAR(20)
  77. NOM VARCHAR(255)
  78. QUANTITE CURRENCY
  79. VARIATION CURRENCY
  80. DATE_ACHAT DATETIME
  81. DATE_VENTE DATETIME
  82. DATE_COURS DATETIME
  83. PRIX_ACHAT CURRENCY
  84. PRIX_VENTE CURRENCY
  85. PRIX_COURS CURRENCY
  86. PRIX_OBJECTIF CURRENCY
  87. FRAIS_ACHAT CURRENCY
  88. FRAIS_VENTE CURRENCY
  89. PERF_TAUX CURRENCY
  90. PERF_MONTANT CURRENCY
  91. TYPE SMALLINT
  92. IN_COURS BIT
  93. ACTIVE BIT
  94. DATE_CREATE TIMESTAMP
  95. PRIX_OPEN CURRENCY
  96. PRIX_BAS CURRENCY
  97. PRIX_HAUT CURRENCY
  98. VOLUME INTEGER
  99. BEFORE_DATE_COURS DATETIME
  100. BEFORE_PRIX_COURS CURRENCY
  101. PLACE VARCHAR(5)
  102. TOTAL_ACHAT CURRENCY
  103. TOTAL_VENTE CURRENCY
  104. TOTAL_COURS CURRENCY
  105. ALERT_MIN CURRENCY
  106. ALERT_MAX CURRENCY
  107. MARKET INTEGER
  108. WORK VARCHAR(2000)
  109. SECTOR INTEGER
  110. NO_RISK BIT
  111. ID_FRAIS INTEGER
  112. ID_FUSION INTEGER
  113. ID_MARQUEUR1 INTEGER
  114. COMMENT VARCHAR(100)
  115. INDEX_COLOR INTEGER
  116. ALERT_SUIVEUR CURRENCY
  117. ID_DEVISE INTEGER
  118. TICKER VARCHAR(20)
  119. PRIX_01JANV CURRENCY
  120. YEAR_01JANV INTEGER
  121. COMMENT_ACHAT VARCHAR(100)
  122. COMMENT_VENTE VARCHAR(100)
  123. ID_MARQUEUR2 INTEGER
  124. ID_MARQUEUR3 INTEGER
  125. COEF_MULTI CURRENCY
  126. TAUX_ACHAT CURRENCY
  127. TAUX_VENTE CURRENCY
  128. COEF_SLIP CURRENCY
  129. ZONE1 VARCHAR(50)
  130. ZONE2 VARCHAR(50)
  131. ZONE3 VARCHAR(50)
  132. ZONE4 VARCHAR(50)
  133. ZONE5 VARCHAR(50)
  134. ZONE6 VARCHAR(50)
  135. ZONE7 VARCHAR(50)
  136. ZONE8 VARCHAR(50)
  137. TTF BIT
  138. INDEX_COLOR_BG INTEGER
  139. FRAIS_ACHAT_D CURRENCY
  140. FRAIS_VENTE_D CURRENCY
  141. LIB_COURS1 VARCHAR(25)
  142. LIB_COURS2 VARCHAR(25)
  143. COURS1 CURRENCY
  144. COURS2 CURRENCY
  145. ###TABLE_DATA_HISTORIQUE
  146. ###TABLE_STRUCT_INDICE
  147. CODE VARCHAR(20)
  148. NOM VARCHAR(255)
  149. DATE_COURS DATETIME
  150. VARIATION CURRENCY
  151. PRIX_COURS CURRENCY
  152. PRIX_OPEN CURRENCY
  153. PRIX_BAS CURRENCY
  154. PRIX_HAUT CURRENCY
  155. PLACE VARCHAR(5)
  156. ORDER INTEGER
  157. ID_DEVISE INTEGER
  158. ###TABLE_DATA_INDICE
  159. FR0003500008|CAC 40||0|0|0|0|0|p|0|0|
  160. FR0003999481|SBF 120||0|0|0|0|0|p|2|0|
  161. FR0003999499|SBF 250||0|0|0|0|0|p|3|0|
  162. ABC003500403|Nasdaq Composite||0|0|0|0|0|u|5|1|
  163. ABC003500395|Dow Jones||0|0|0|0|0|x|6|1|
  164. ABC003500361|Nikkei Index||0|0|0|0|0|p|7|4|
  165. BE0389555039|BEL 20||0|0|0|0|0|g|8|0|
  166. DE0008469008|Dax 30||0|0|0|0|0|f|9|0|
  167. ABC003500452|FTSE 100||0|0|0|0|0|e|10|2|
  168. CH0009980894|SMI||0|0|0|0|0|s|11|3|
  169. ###TABLE_STRUCT_LIQUIDITE
  170. ID_LIQUIDITE INTEGER AUTO_INCREMENT='1'
  171. ID_ORIGINE SMALLINT
  172. DATE_OPERATION DATE
  173. MONTANT CURRENCY
  174. COMMENT VARCHAR(100)
  175. TYPE_OPERATION SMALLINT
  176. ID_MEMBER INTEGER
  177. ###TABLE_DATA_LIQUIDITE
  178. ###TABLE_STRUCT_LOOK
  179. CODE VARCHAR(20)
  180. NOM VARCHAR(100)
  181. PRIX_COURS CURRENCY
  182. VARIATION CURRENCY
  183. DATE_COURS DATETIME
  184. DATE_ALERT DATE
  185. ALERT_BAS CURRENCY
  186. ALERT_HAUT CURRENCY
  187. PRIX_REF CURRENCY
  188. DATE_REF DATE
  189. VARIATION_REF CURRENCY
  190. PLACE VARCHAR(5)
  191. ID_LOOK_CATEGORY INTEGER
  192. PRIX_OPEN CURRENCY
  193. PRIX_BAS CURRENCY
  194. PRIX_HAUT CURRENCY
  195. VOLUME CURRENCY
  196. COMMENT VARCHAR(100)
  197. ALERT_SUIVEUR CURRENCY
  198. INDEX_COLOR INTEGER
  199. TICKER VARCHAR(50)
  200. SECTOR INTEGER
  201. MARKET INTEGER
  202. DIVIDENDE CURRENCY
  203. ID_DEVISE INTEGER
  204. ###TABLE_DATA_LOOK
  205. ###TABLE_STRUCT_LOOKPOSTIT
  206. CODE VARCHAR(20)
  207. PLACE VARCHAR(5)
  208. POSTIT VARCHAR(2000)
  209. COLOR INTEGER
  210. ID_LOOK_CATEGORY INTEGER
  211. ###TABLE_DATA_LOOKPOSTIT
  212. ###TABLE_STRUCT_MAIL
  213. HOST_NAME VARCHAR(255)
  214. HOST_USER VARCHAR(50)
  215. HOST_PASSWORD VARCHAR(20)
  216. HOST_PORT INTEGER DEFAULT='25'
  217. EMAIL_TO VARCHAR(100)
  218. EMAIL_FROM VARCHAR(100)
  219. ID_HOUR_OPEN SMALLINT
  220. ID_HOUR_CLOSE SMALLINT
  221. ID_FREQUENCE SMALLINT
  222. ACTIVE BIT
  223. HTML BIT
  224. ###TABLE_DATA_MAIL
  225. ex : smtp.orange.fr|||25|mail travail|mail maison|18|36|10|1|1|
  226. ###TABLE_STRUCT_MAILACTION
  227. CODE VARCHAR(20)
  228. PLACE VARCHAR(5)
  229. ###TABLE_DATA_MAILACTION
  230. ###TABLE_STRUCT_OPERATION
  231. ID_OPERATION INTEGER AUTO_INCREMENT='1'
  232. DATE_OPERATION DATE
  233. ID_ACTION INTEGER
  234. TYPE_OPERATION SMALLINT
  235. MONTANT CURRENCY
  236. COMMENT VARCHAR(100)
  237. WORK1 VARCHAR(2000)
  238. WORK2 VARCHAR(2000)
  239. ID_MASSE INTEGER
  240. ID_DEVISE INTEGER
  241. ###TABLE_DATA_OPERATION
  242. ###TABLE_STRUCT_ORIGINE
  243. ID_ORIGINE SMALLINT AUTO_INCREMENT='2'
  244. LIB_ORIGINE VARCHAR(50)
  245. LIQUIDITE CURRENCY
  246. MONTANT CURRENCY
  247. FRAIS1 CURRENCY
  248. FRAIS_1_TYPE SMALLINT
  249. FRAIS2 CURRENCY
  250. FRAIS_2_TYPE SMALLINT
  251. MONTANT2 CURRENCY
  252. FRAIS3 CURRENCY
  253. FRAIS_3_TYPE SMALLINT
  254. TYPE SMALLINT
  255. ISHT BIT
  256. TVA CURRENCY
  257. ID_DEVISE INTEGER
  258. URL_COURTIER VARCHAR(200)
  259. IMPOT_BOURSE BIT
  260. FRAIS_MIN CURRENCY
  261. MAJ_DDG BIT
  262. MAJ_AF BIT
  263. MAJ_SRD BIT
  264. MAJ_DIVIDENDE BIT
  265. MAJ_DIVERS1 BIT
  266. IMPOT_FISCAL BIT
  267. CRD_ISHT BIT
  268. CRD_AR_FREE BIT
  269. TVA_CODE VARCHAR(10)
  270. CRD_HA CURRENCY
  271. CRD_VT CURRENCY
  272. CRD_TYPE_HA INTEGER
  273. CRD_TYPE_VT INTEGER
  274. CRD_MIN_HA CURRENCY
  275. CRD_MIN_VT CURRENCY
  276. LEVIER_LIQUIDITE CURRENCY
  277. LEVIER_ACTION_FR CURRENCY
  278. LEVIER_OBL CURRENCY
  279. REPORT_TAUX CURRENCY
  280. REPORT_MIN CURRENCY
  281. CRD_DAY_TYPE INTEGER
  282. COMMENT1 VARCHAR(100)
  283. MAJ_DIVERS2 BIT
  284. MAJ_DIVERS3 BIT
  285. MAJ_DIVERSO1 BIT
  286. MAJ_DIVERSO2 BIT
  287. MAJ_DIVERSO3 BIT
  288. REF_DATE DATE
  289. REF_PRIX CURRENCY
  290. MAJ_INTERET BIT
  291. INTERET_TAUX1 CURRENCY
  292. INTERET_TAUX2 CURRENCY
  293. INTERET_DATE2 DATE
  294. INTERET_TAUX3 CURRENCY
  295. INTERET_DATE3 DATE
  296. MAJ_DS BIT
  297. MASK_ORIGINE BIT
  298. IMPORT_T_SEPARATOR VARCHAR(5)
  299. IMPORT_T_DATE_FORMAT INTEGER
  300. IMPORT_T_CODE INTEGER
  301. IMPORT_T_NOM INTEGER
  302. IMPORT_T_TYPE_IMPORT INTEGER
  303. IMPORT_T_QUANTITE_ACHAT INTEGER
  304. IMPORT_T_DATE_ACHAT INTEGER
  305. IMPORT_T_PRIX_ACHAT INTEGER
  306. IMPORT_T_FRAIS_ACHAT INTEGER
  307. IMPORT_T_QUANTITE_VENTE INTEGER
  308. IMPORT_T_DATE_VENTE INTEGER
  309. IMPORT_T_PRIX_VENTE INTEGER
  310. IMPORT_T_FRAIS_VENTE INTEGER
  311. IMPORT_T_TYPE_ACHAT INTEGER
  312. ID_MARQUEUR_ORIGINE1 INTEGER
  313. ID_MARQUEUR_ORIGINE2 INTEGER
  314. ID_MARQUEUR_ORIGINE3 INTEGER
  315. MAJ_HA_VT BIT
  316. COMMENT2 VARCHAR(100)
  317. COMMENT3 VARCHAR(100)
  318. COMMENT4 VARCHAR(100)
  319. COMMENT5 VARCHAR(100)
  320. COMMENT6 VARCHAR(100)
  321. COMMENT7 VARCHAR(100)
  322. COMMENT8 VARCHAR(100)
  323. REF_SEE BIT
  324. MAJ_CRD BIT
  325. MAJ_REPORT BIT
  326. MAJ_IMPOT BIT
  327. MAJ_FRAIS_GESTION BIT
  328. IMPORT_T_COMMENT_ACHAT INTEGER
  329. IMPORT_T_COMMENT_VENTE INTEGER
  330. IMPORT_T_SENS INTEGER
  331. IMPORT_OT_SEPARATOR VARCHAR(5)
  332. IMPORT_OT_DATE_FORMAT INTEGER
  333. IMPORT_OT_CODE INTEGER
  334. IMPORT_OT_TYPE INTEGER
  335. IMPORT_OT_TYPE_FILTRE VARCHAR(20)
  336. IMPORT_OT_PRIX INTEGER
  337. IMPORT_OT_DATE INTEGER
  338. IMPORT_OT_COMMENT INTEGER
  339. IMPORT_OT_DIV VARCHAR(20)
  340. IMPORT_OT_CRD VARCHAR(20)
  341. IMPORT_OT_REP VARCHAR(20)
  342. IMPORT_OT_FP VARCHAR(20)
  343. IMPORT_OT_RP VARCHAR(20)
  344. IMPORT_OT_LIQUIDITE BIT
  345. INTERET_TAUX4 CURRENCY
  346. INTERET_DATE4 DATE
  347. INTERET_TAUX5 CURRENCY
  348. INTERET_DATE5 DATE
  349. MAJ_PERFINIT BIT
  350. CIVILITE VARCHAR(50)
  351. PRENOM VARCHAR(50)
  352. NOM VARCHAR(50)
  353. SOCIETE VARCHAR(50)
  354. ADRESSE1 VARCHAR(200)
  355. ADRESSE2 VARCHAR(200)
  356. CODE_POSTAL VARCHAR(20)
  357. VILLE VARCHAR(50)
  358. TEL VARCHAR(50)
  359. FAX VARCHAR(50)
  360. EMAIL VARCHAR(50)
  361. IMPORT_OP_SEPARATOR VARCHAR(5)
  362. IMPORT_OP_DATE_FORMAT INTEGER
  363. IMPORT_OP_TYPE INTEGER
  364. IMPORT_OP_TYPE_FILTRE VARCHAR(20)
  365. IMPORT_OP_PRIX INTEGER
  366. IMPORT_OP_DATE INTEGER
  367. IMPORT_OP_COMMENT INTEGER
  368. IMPORT_OP_APPORT VARCHAR(20)
  369. IMPORT_OP_RETRAIT VARCHAR(20)
  370. IMPORT_OP_DDG VARCHAR(20)
  371. IMPORT_OP_INTERET VARCHAR(20)
  372. IMPORT_OP_IMPOT VARCHAR(20)
  373. IMPORT_OP_LIQUIDITE BIT
  374. MAX_APPORT CURRENCY
  375. DATE_OUVERTURE DATE
  376. DATE_ECHEANCE DATE
  377. TEXTE VARCHAR(5000)
  378. IMPOT_TTF INTEGER
  379. MAJ_TTF BIT
  380. IMPORT_OT_TTF VARCHAR(20)
  381. IMPORT_OP_TTF VARCHAR(20)
  382. MAJ_DDG_PERF BIT
  383. MAJ_IMPOT_PERF BIT
  384. MAJ_FRAIS_GESTION_PERF BIT
  385. MAJ_AF_PERF BIT
  386. MAJ_DS_PERF BIT
  387. MAJ_SRD_PERF BIT
  388. MAJ_CRD_PERF BIT
  389. MAJ_TTF_PERF BIT
  390. MAJ_REPORT_PERF BIT
  391. MAJ_DIVIDENDE_PERF BIT
  392. MAJ_INTERET_PERF BIT
  393. MAJ_PERFINIT_PERF BIT
  394. MAJ_DIVERS1_PERF BIT
  395. MAJ_DIVERS2_PERF BIT
  396. MAJ_DIVERS3_PERF BIT
  397. MAJ_DIVERSO1_PERF BIT
  398. MAJ_DIVERSO2_PERF BIT
  399. MAJ_DIVERSO3_PERF BIT
  400. MAJ_DIVERS4 BIT
  401. MAJ_DIVERS5 BIT
  402. MAJ_DIVERS4_PERF BIT
  403. MAJ_DIVERS5_PERF BIT
  404. MAJ_DIVERSO4 BIT
  405. MAJ_DIVERSO5 BIT
  406. MAJ_DIVERSO4_PERF BIT
  407. MAJ_DIVERSO5_PERF BIT
  408. FAVORI_ORIGINE BIT
  409. ###TABLE_DATA_ORIGINE
  410. ###TABLE_STRUCT_POSTIT
  411. ID INTEGER
  412. POSTIT VARCHAR(2000)
  413. COLOR INTEGER
  414. ###TABLE_DATA_POSTIT
  415. ###TABLE_STRUCT_PREFERENCE
  416. SEE_VARIATION BIT
  417. SEE_PRIX_OPEN BIT
  418. SEE_PRIX_BAS BIT
  419. SEE_PRIX_HAUT BIT
  420. SEE_VOLUME BIT
  421. SEE_PRIX_OBJECTIF BIT
  422. SEE_BIG_SCREEN BIT
  423. AUTO_INDICE BIT
  424. SORT INTEGER
  425. ISIN BIT
  426. URL1 VARCHAR(255)
  427. PASSWORD VARCHAR(50)
  428. PROXY_HOST VARCHAR(255)
  429. PROXY_PORT INTEGER
  430. PROXY_USER VARCHAR(50)
  431. PROXY_PASSWORD VARCHAR(20)
  432. IMPORT_FILE VARCHAR(255)
  433. IMPORT_SEPARATOR VARCHAR(5)
  434. IMPORT_CODE INTEGER
  435. IMPORT_DATE INTEGER
  436. IMPORT_COURS INTEGER
  437. IMPORT_OPEN INTEGER
  438. IMPORT_HAUT INTEGER
  439. IMPORT_BAS INTEGER
  440. IMPORT_VOLUME INTEGER
  441. ID_GROUPE VARCHAR(100)
  442. COL_WIDTH_0 INTEGER
  443. COL_WIDTH_1 INTEGER
  444. COL_WIDTH_2 INTEGER
  445. COL_WIDTH_3 INTEGER
  446. COL_WIDTH_4 INTEGER
  447. COL_WIDTH_5 INTEGER
  448. COL_WIDTH_6 INTEGER
  449. COL_WIDTH_7 INTEGER
  450. COL_WIDTH_8 INTEGER
  451. COL_WIDTH_9 INTEGER
  452. COL_WIDTH_10 INTEGER
  453. COL_WIDTH_11 INTEGER
  454. COL_WIDTH_12 INTEGER
  455. COL_WIDTH_13 INTEGER
  456. COL_WIDTH_14 INTEGER
  457. COL_WIDTH_15 INTEGER
  458. SEE_DATES INTEGER
  459. COL_WIDTH_16 INTEGER
  460. COL_WIDTH_17 INTEGER
  461. COL_WIDTH_18 INTEGER
  462. COL_WIDTH_19 INTEGER
  463. COL_WIDTH_20 INTEGER
  464. COL_WIDTH_21 INTEGER
  465. FONT_NAME VARCHAR(50)
  466. FONT_SIZE INTEGER
  467. FONT_GRAPH BIT
  468. ID_SORT INTEGER
  469. ASC_SORT BIT
  470. DELETE_LIQUIDITE BIT
  471. FRAIS_EVAL BIT
  472. GRID_COLOR BIT
  473. IMPOT_TAUX0 CURRENCY
  474. IMPOT_TAUX1 CURRENCY
  475. IMPOT_TAUX2 CURRENCY
  476. IMPOT_TRANCHE0 CURRENCY
  477. IMPOT_PLAFOND CURRENCY
  478. IMPOT_ARRONDI BIT
  479. IMPOT_FRAIS BIT
  480. IMPOT_PM BIT
  481. IMPOT_SM BIT
  482. IMPOT_NM BIT
  483. COL_WIDTH_22 INTEGER
  484. COL_WIDTH_23 INTEGER
  485. COL_WIDTH_24 INTEGER
  486. COL_WIDTH_25 INTEGER
  487. COL_WIDTH_26 INTEGER
  488. COL_WIDTH_27 INTEGER
  489. COL_WIDTH_28 INTEGER
  490. COL_WIDTH_29 INTEGER
  491. COL_WIDTH_30 INTEGER
  492. COL_WIDTH_31 INTEGER
  493. COL_WIDTH_32 INTEGER
  494. COL_WIDTH_33 INTEGER
  495. COL_WIDTH_34 INTEGER
  496. COL_WIDTH_35 INTEGER
  497. COL_WIDTH_36 INTEGER
  498. COL_WIDTH_37 INTEGER
  499. COL_WIDTH_38 INTEGER
  500. COL_WIDTH_39 INTEGER
  501. COL_WIDTH_40 INTEGER
  502. COL_WIDTH_41 INTEGER
  503. COL_WIDTH_42 INTEGER
  504. COL_WIDTH_43 INTEGER
  505. COL_WIDTH_44 INTEGER
  506. COL_WIDTH_45 INTEGER
  507. COL_WIDTH_46 INTEGER
  508. COL_WIDTH_47 INTEGER
  509. COL_WIDTH_48 INTEGER
  510. COL_WIDTH_49 INTEGER
  511. COL_WIDTH_50 INTEGER
  512. COL_POS_0 INTEGER
  513. COL_POS_1 INTEGER
  514. COL_POS_2 INTEGER
  515. COL_POS_3 INTEGER
  516. COL_POS_4 INTEGER
  517. COL_POS_5 INTEGER
  518. COL_POS_6 INTEGER
  519. COL_POS_7 INTEGER
  520. COL_POS_8 INTEGER
  521. COL_POS_9 INTEGER
  522. COL_POS_10 INTEGER
  523. COL_POS_11 INTEGER
  524. COL_POS_12 INTEGER
  525. COL_POS_13 INTEGER
  526. COL_POS_14 INTEGER
  527. COL_POS_15 INTEGER
  528. COL_POS_16 INTEGER
  529. COL_POS_17 INTEGER
  530. COL_POS_18 INTEGER
  531. COL_POS_19 INTEGER
  532. COL_POS_20 INTEGER
  533. COL_POS_21 INTEGER
  534. COL_POS_22 INTEGER
  535. COL_POS_23 INTEGER
  536. COL_POS_24 INTEGER
  537. COL_POS_25 INTEGER
  538. COL_POS_26 INTEGER
  539. COL_POS_27 INTEGER
  540. COL_POS_28 INTEGER
  541. COL_POS_29 INTEGER
  542. COL_POS_30 INTEGER
  543. COL_POS_31 INTEGER
  544. COL_POS_32 INTEGER
  545. COL_POS_33 INTEGER
  546. COL_POS_34 INTEGER
  547. COL_POS_35 INTEGER
  548. COL_POS_36 INTEGER
  549. COL_POS_37 INTEGER
  550. COL_POS_38 INTEGER
  551. COL_POS_39 INTEGER
  552. COL_POS_40 INTEGER
  553. COL_POS_41 INTEGER
  554. COL_POS_42 INTEGER
  555. COL_POS_43 INTEGER
  556. COL_POS_44 INTEGER
  557. COL_POS_45 INTEGER
  558. COL_POS_46 INTEGER
  559. COL_POS_47 INTEGER
  560. COL_POS_48 INTEGER
  561. COL_POS_49 INTEGER
  562. COL_POS_50 INTEGER
  563. PROXY_ACTIVE BIT
  564. FORM_TOP_1 INTEGER
  565. FORM_LEFT_1 INTEGER
  566. FORM_WIDTH_1 INTEGER
  567. FORM_HEIGHT_1 INTEGER
  568. FORM_TOP_2 INTEGER
  569. FORM_LEFT_2 INTEGER
  570. FORM_WIDTH_2 INTEGER
  571. FORM_HEIGHT_2 INTEGER
  572. FORM_TOP_3 INTEGER
  573. FORM_LEFT_3 INTEGER
  574. FORM_WIDTH_3 INTEGER
  575. FORM_HEIGHT_3 INTEGER
  576. FORM_TOP_4 INTEGER
  577. FORM_LEFT_4 INTEGER
  578. FORM_WIDTH_4 INTEGER
  579. FORM_HEIGHT_4 INTEGER
  580. FORM_TOP_5 INTEGER
  581. FORM_LEFT_5 INTEGER
  582. FORM_WIDTH_5 INTEGER
  583. FORM_HEIGHT_5 INTEGER
  584. MAX_TRANSACTION INTEGER
  585. ALERT_HB BOOLEAN
  586. ALERT_TAUX CURRENCY
  587. ALERT_FIX_MIN CURRENCY
  588. ALERT_FIX_MAX CURRENCY
  589. ALL_ORIGINE BIT
  590. COL_WIDTH_51 INTEGER
  591. COL_POS_51 INTEGER
  592. COL_WIDTH_52 INTEGER
  593. COL_POS_52 INTEGER
  594. COL_WIDTH_53 INTEGER
  595. COL_POS_53 INTEGER
  596. COL_WIDTH_54 INTEGER
  597. COL_POS_54 INTEGER
  598. COL_WIDTH_55 INTEGER
  599. COL_POS_55 INTEGER
  600. COL_WIDTH_56 INTEGER
  601. COL_POS_56 INTEGER
  602. COL_WIDTH_57 INTEGER
  603. COL_POS_57 INTEGER
  604. COL_WIDTH_58 INTEGER
  605. COL_POS_58 INTEGER
  606. COL_WIDTH_59 INTEGER
  607. COL_POS_59 INTEGER
  608. COL_WIDTH_60 INTEGER
  609. COL_POS_60 INTEGER
  610. DIR_SAVE VARCHAR(500)
  611. SEE_BIG_SCREEN_ALL BIT
  612. SEE_COURS_INDEX SMALLINT
  613. VALO_START DATE
  614. SEE_STAT_INDEX SMALLINT
  615. SEE_STAT_TAB SMALLINT
  616. SEE_STAT_FLAG BIT
  617. SEE_STAT_DETAIL BIT
  618. FORM_TOP_0 INTEGER
  619. FORM_LEFT_0 INTEGER
  620. FORM_WIDTH_0 INTEGER
  621. FORM_HEIGHT_0 INTEGER
  622. LG_GRID_COLOR INTEGER
  623. SEE_COURS_COMPARAISON INTEGER
  624. SEE_COURS_AT INTEGER
  625. SEE_STAT_COMPARAISON INTEGER
  626. TIME_OUT INTEGER
  627. RISK_INDEX INTEGER
  628. RISK_VALO BIT
  629. YEAR_PERIODE INTEGER
  630. YEAR_DELTA BIT
  631. YEAR_TAB INTEGER
  632. YEAR_SELECT INTEGER
  633. SEE_VALO_COMPARAISON INTEGER
  634. IMPORT_DATE_FORMAT INTEGER
  635. GRAPH_LIQ_VALEUR BIT
  636. IMPOT_AUTRES BIT
  637. IMPOT_WAR BIT
  638. IMPOT_OBL BIT
  639. IMPOT_BS BIT
  640. DATE_LAST_PURGE DATE
  641. PRINT_ISIN BIT
  642. FULL_LAST_SAVE DATE
  643. PRINT_COURS BIT
  644. PRINT_DATE DATE
  645. COL_WIDTH_61 INTEGER
  646. COL_POS_61 INTEGER
  647. COL_WIDTH_62 INTEGER
  648. COL_POS_62 INTEGER
  649. COL_WIDTH_63 INTEGER
  650. COL_POS_63 INTEGER
  651. COL_WIDTH_64 INTEGER
  652. COL_POS_64 INTEGER
  653. COL_WIDTH_65 INTEGER
  654. COL_POS_65 INTEGER
  655. COL_WIDTH_66 INTEGER
  656. COL_POS_66 INTEGER
  657. COL_WIDTH_67 INTEGER
  658. COL_POS_67 INTEGER
  659. COL_WIDTH_68 INTEGER
  660. COL_POS_68 INTEGER
  661. COL_WIDTH_69 INTEGER
  662. COL_POS_69 INTEGER
  663. COL_WIDTH_70 INTEGER
  664. COL_POS_70 INTEGER
  665. DATE_MASK_START DATE
  666. SEE_MASK BIT
  667. NB_DAY_LIQUIDATION INTEGER
  668. LAST_LIQUIDATION DATE
  669. PRINT_FRAIS BIT
  670. CHARTVOL_HEIGHT INTEGER
  671. SEE_COURS_DETENTION BIT
  672. PRINT_DATE_AV SMALLINT
  673. PRINT_COLOR BIT
  674. NB_FUSION INTEGER
  675. SEE_FUSION BIT
  676. SEE_DEVISE_PARITE BIT
  677. REPRISE_FUSION BIT
  678. DIR_EXPORT VARCHAR(500)
  679. TYPE_JOURNAL INTEGER
  680. SORT_TASK_INDEX INTEGER
  681. SORT_TASK_DESC BIT
  682. TYPE_ACTION INTEGER
  683. NOM_MARQUEUR1 VARCHAR(30)
  684. FLUX_SOLDEE BIT
  685. FLUX_LOOK BIT
  686. FLUX_INDICE BIT
  687. FLUX_DEVISE BIT
  688. GRAPH_LIQ_MARQUEUR BIT
  689. GRAPH_INDEX INTEGER
  690. DIR_ATTACHMENT VARCHAR(255)
  691. COL_WIDTH_71 INTEGER
  692. COL_POS_71 INTEGER
  693. COL_WIDTH_72 INTEGER
  694. COL_POS_72 INTEGER
  695. COL_WIDTH_73 INTEGER
  696. COL_POS_73 INTEGER
  697. COL_WIDTH_74 INTEGER
  698. COL_POS_74 INTEGER
  699. COL_WIDTH_75 INTEGER
  700. COL_POS_75 INTEGER
  701. COL_WIDTH_76 INTEGER
  702. COL_POS_76 INTEGER
  703. COL_WIDTH_77 INTEGER
  704. COL_POS_77 INTEGER
  705. COL_WIDTH_78 INTEGER
  706. COL_POS_78 INTEGER
  707. COL_WIDTH_79 INTEGER
  708. COL_POS_79 INTEGER
  709. COL_WIDTH_80 INTEGER
  710. COL_POS_80 INTEGER
  711. COL_WIDTH_81 INTEGER
  712. COL_POS_81 INTEGER
  713. COL_WIDTH_82 INTEGER
  714. COL_POS_82 INTEGER
  715. COL_WIDTH_83 INTEGER
  716. COL_POS_83 INTEGER
  717. COL_WIDTH_84 INTEGER
  718. COL_POS_84 INTEGER
  719. COL_WIDTH_85 INTEGER
  720. COL_POS_85 INTEGER
  721. COL_WIDTH_86 INTEGER
  722. COL_POS_86 INTEGER
  723. COL_WIDTH_87 INTEGER
  724. COL_POS_87 INTEGER
  725. COL_WIDTH_88 INTEGER
  726. COL_POS_88 INTEGER
  727. COL_WIDTH_89 INTEGER
  728. COL_POS_89 INTEGER
  729. COL_WIDTH_90 INTEGER
  730. COL_POS_90 INTEGER
  731. SOLDEE_INDEX INTEGER
  732. FLUX_WAIT BIT
  733. SORT_WAIT_INDEX INTEGER
  734. SORT_WAIT_DESC BIT
  735. SORT_LOOK_INDEX INTEGER
  736. SORT_LOOK_DESC BIT
  737. SEL_EXPORT VARCHAR(100)
  738. SAVE_EXPORT_FILE BIT
  739. BILAN_PERIODE INTEGER
  740. COLONNES_WIDTH_ORIGINE VARCHAR(255)
  741. PRINT_DATE_ACHAT BIT
  742. PRINT_DATE_VENTE BIT
  743. PRINT_ORIGINE BIT
  744. PRINT_INDICE_CAC40 BIT
  745. PRINT_LOGO VARCHAR(255)
  746. PRINT_TITLE VARCHAR(10000)
  747. LIB_DIVERS1 VARCHAR(25)
  748. SEE_DEVISE_EUR BIT
  749. PRINT_CATEGORIE BIT
  750. DATE_RETRO DATE
  751. SEE_RETRO BIT
  752. ID_LOOK_CATEGORY INTEGER
  753. ID_SORT_ORIGINE INTEGER
  754. ASC_SORT_ORIGINE BIT
  755. PRINT_LIB_ACHAT VARCHAR(50)
  756. PRINT_LIB_VENTE VARCHAR(50)
  757. PRINT_LIB_FRAIS VARCHAR(50)
  758. PRINT_LIB_PERF VARCHAR(50)
  759. PRINT_PERF BIT
  760. PRINT_TOTAL_PERF BIT
  761. LIB_DIVERS2 VARCHAR(25)
  762. LIB_DIVERS3 VARCHAR(25)
  763. LIB_DIVERSO1 VARCHAR(25)
  764. LIB_DIVERSO2 VARCHAR(25)
  765. LIB_DIVERSO3 VARCHAR(25)
  766. EXPORT_FORMAT INTEGER
  767. IMPOT_TRANCHE1 CURRENCY
  768. IMPOT_R_TRANCHE0 CURRENCY
  769. IMPOT_R_TAUX0 CURRENCY
  770. IMPOT_R_TAUX1 CURRENCY
  771. IMPOT_R_PLAFOND CURRENCY
  772. EXCLURE_AR BIT
  773. FILE_PORTEE INTEGER
  774. TEXT_FIND VARCHAR(50)
  775. ALERT_FIX_SUIVEUR CURRENCY
  776. DIR_CD VARCHAR(250)
  777. IMPORT_IN_MEROPS BIT
  778. SEPARATEUR_MILLIER BIT
  779. PRINT_OP_AR BIT
  780. PRINT_OP BIT
  781. GROUP_DIVIDENDE BIT
  782. SEE_MASK_TS BIT
  783. SEE_MASK_OP BIT
  784. SEE_MASK_OT BIT
  785. CALCULATRICE VARCHAR(255)
  786. TYPE_FIND INTEGER
  787. MODE_VALO INTEGER
  788. ID_NEWS_RSS INTEGER
  789. PRINT_OBJ_LOSS BIT
  790. PRINT_LIB_OBJ_LOSS VARCHAR(50)
  791. PRINT_OP_MASK BIT
  792. SEE_ONLY_IN_COURS BIT
  793. SEE_DEVISE_PARITE_ID INTEGER
  794. PRINT_TICKER BIT
  795. DO_ICON_TRAY BIT
  796. PRINT_COMMENT BIT
  797. PV_PMP BIT
  798. SEE_VALEUR BIT
  799. PRINT_PRU BIT
  800. MODE_GRAPH INTEGER
  801. INDEX_DELTA INTEGER
  802. RENFORT_MT CURRENCY
  803. RENFORT_GAIN_ONLY BIT
  804. RENFORT_LIQUIDITE BIT
  805. PRINT_COURS_ACHAT BIT
  806. PRINT_TOTAL_ACHAT BIT
  807. PRINT_COURS_VENTE BIT
  808. PRINT_TOTAL_VENTE BIT
  809. GRAPH_LIQ_SECTOR BIT
  810. GRAPH_LIQ_MARKET BIT
  811. PRINT_COMMENT_ORDRE BIT
  812. NOM_MARQUEUR2 VARCHAR(30)
  813. NOM_MARQUEUR3 VARCHAR(30)
  814. FILE_CSS VARCHAR(255)
  815. FONT_SIZE_HTML INTEGER
  816. SOLDEE_NOT_SEE_DETAIL BIT
  817. SOLDEE_SEE_COURS BIT
  818. PERFORMANCE_INDEX INTEGER
  819. PERFORMANCE_NOT_SEE_VALEUR BIT
  820. PERFORMANCE_NOT_SEE_OP BIT
  821. PERFORMANCE_NOT_SEE_LIQUIDITE BIT
  822. DEVISE_SUP_CODE VARCHAR(20)
  823. DEVISE_SUP_NOM VARCHAR(255)
  824. DEVISE_SUP_SIGLE VARCHAR(3)
  825. PERFORMANCE_NOT_SEE_OT BIT
  826. TRI_GRAPH INTEGER
  827. SERIE_GRAPH INTEGER
  828. PERFORMANCE_NOT_SEE_PERF_COURS BIT
  829. PRINT_TOTAL_PRU BIT
  830. SEE_PERF_COMPARAISON INTEGER
  831. SAVE_FREQUENCE INTEGER
  832. STAT_START DATE
  833. IMPORT_T_FILE VARCHAR(255)
  834. IMPORT_T_SEPARATOR VARCHAR(5)
  835. IMPORT_T_DATE_FORMAT INTEGER
  836. IMPORT_T_LIQUIDITE BIT
  837. IMPORT_T_CODE INTEGER
  838. IMPORT_T_NOM INTEGER
  839. IMPORT_T_TYPE_IMPORT INTEGER
  840. IMPORT_T_QUANTITE_ACHAT INTEGER
  841. IMPORT_T_DATE_ACHAT INTEGER
  842. IMPORT_T_PRIX_ACHAT INTEGER
  843. IMPORT_T_FRAIS_ACHAT INTEGER
  844. IMPORT_T_QUANTITE_VENTE INTEGER
  845. IMPORT_T_DATE_VENTE INTEGER
  846. IMPORT_T_PRIX_VENTE INTEGER
  847. IMPORT_T_FRAIS_VENTE INTEGER
  848. IMPORT_T_VAD BIT
  849. IMPORT_T_TYPE_ACHAT INTEGER
  850. NOM_MARQUEUR_ORIGINE1 VARCHAR(30)
  851. NOM_MARQUEUR_ORIGINE2 VARCHAR(30)
  852. NOM_MARQUEUR_ORIGINE3 VARCHAR(30)
  853. ALL_SEUIL BIT
  854. PRINT_LIQUIDITE BIT
  855. PRINT_VALORISATION BIT
  856. PRINT_TOTAL_COURS BIT
  857. PRINT_TOTAL_PERF_REF BIT
  858. JOURNAL_BALANCE INTEGER
  859. PRINT_PERF_TYPE INTEGER
  860. INIT_VARIATION BIT
  861. IMPORT_T_0 BIT
  862. SEE_BULLE BIT
  863. SEE_CROIX INTEGER
  864. PALMARES_INDEX INTEGER
  865. PALMARES_TRANS BIT
  866. PALMARES_VALEUR BIT
  867. PALMARES_INDICE BIT
  868. PALMARES_ORIGINE BIT
  869. PALMARES_LOOK BIT
  870. PALMARES_DEVISE BIT
  871. PALMARES_SEE INTEGER
  872. REGION_ID_LANGUE INTEGER
  873. REGION_ID_DEVISE INTEGER
  874. REGION_SRD BIT
  875. REGION_FISCALITE BIT
  876. SEE_COMPARATEUR_INDEX INTEGER
  877. SEE_COMPARATEUR_PERIODE INTEGER
  878. SEE_COMPARATEUR_DATE_START DATE
  879. SEE_COMPARATEUR_DATE_END DATE
  880. SEE_COMPARATEUR_SERIE INTEGER
  881. FIND_CROISE INTEGER
  882. TYPE_FIND2 INTEGER
  883. TEXT_FIND2 VARCHAR(50)
  884. MEROPS_OS INTEGER
  885. COURS_START DATE
  886. PRINT_QUANTITE_TYPE INTEGER
  887. IMPORT_OT_FILE VARCHAR(255)
  888. IMPORT_OT_LIQUIDITE BIT
  889. HISTO_ECHELLE BIT
  890. HISTO_FLAG BIT
  891. HISTO_LIGNES BIT
  892. HISTO_HB BIT
  893. UPDATE_LETTER_EXE BIT
  894. COMMENT_PORTEE INTEGER
  895. BILAN_COMMENT BIT
  896. HISTO_COMMENT BIT
  897. STAT_COMMENT BIT
  898. SEE_VALO_INDEX INTEGER
  899. SEE_COURS_AT_VOL INTEGER
  900. CALCUL_WITH_FRAIS BIT
  901. PERFORMANCE_ORDRE INTEGER
  902. SEE_01_JANV BIT
  903. HIDE_SCREEN VARCHAR(20)
  904. VL_INDEX INTEGER
  905. BILAN_HAVT BIT
  906. BILAN_STAT BIT
  907. BILAN_COURS BIT
  908. BILAN_QUANTITE BIT
  909. BILAN_PRU BIT
  910. PURGE_MASSE_MOIS INTEGER
  911. MASSE_RAPPORT_DATE DATE
  912. MASSE_RAPPORT_INDEX INTEGER
  913. MASSE_RAPPORT_DETAIL BIT
  914. MASSE_RAPPORT_CANCEL BIT
  915. WIDTH_BIG_SUP INTEGER
  916. VALO_SAVE INTEGER
  917. PRINT_HEAD VARCHAR(10000)
  918. PRINT_CENTER VARCHAR(10000)
  919. PRINT_FOOT VARCHAR(10000)
  920. PRINT_DATE_START INTEGER
  921. CONTACT_SAVE_CLOSE BIT
  922. MASSE_PRINT_TYPE INTEGER
  923. MASSE_PRINT_DELAI INTEGER
  924. PALETTE_GRAPH INTEGER
  925. SEE_DEVISE_USD BIT
  926. TYPE_SEARCH INTEGER
  927. ID_STYLE INTEGER
  928. SEE_EVOL_VEILLE BIT
  929. SEE_EVOL_01JANV BIT
  930. SEE_EVOL_PERIODE1 BIT
  931. SEE_EVOL_PERIODE2 BIT
  932. SEE_EVOL_PERIODE3 BIT
  933. SEE_EVOL_PERIODE4 BIT
  934. SEE_EVOL_PERIODE5 BIT
  935. SEE_EVOL_PERIODE6 BIT
  936. SEE_EVOL_PERIODE7 BIT
  937. SEE_EVOL_PERIODE8 BIT
  938. NB_EVOL_PERIODE1 INTEGER
  939. NB_EVOL_PERIODE2 INTEGER
  940. NB_EVOL_PERIODE3 INTEGER
  941. NB_EVOL_PERIODE4 INTEGER
  942. NB_EVOL_PERIODE5 INTEGER
  943. NB_EVOL_PERIODE6 INTEGER
  944. NB_EVOL_PERIODE7 INTEGER
  945. NB_EVOL_PERIODE8 INTEGER
  946. INDEX_MAIN_TAB2 INTEGER
  947. NB_EVOL_PERIODE1_F INTEGER
  948. NB_EVOL_PERIODE2_F INTEGER
  949. NB_EVOL_PERIODE3_F INTEGER
  950. NB_EVOL_PERIODE4_F INTEGER
  951. NB_EVOL_PERIODE5_F INTEGER
  952. NB_EVOL_PERIODE6_F INTEGER
  953. NB_EVOL_PERIODE7_F INTEGER
  954. NB_EVOL_PERIODE8_F INTEGER
  955. INDEX_MAIN_TAB3 INTEGER
  956. TAILLE_BLOC_X INTEGER
  957. TAILLE_BLOC_Y INTEGER
  958. EVOL_OPTIMIZE BIT
  959. GRILLE_T_DETAIL VARCHAR(200)
  960. GRILLE_T_PERF VARCHAR(200)
  961. GRILLE_T_EVOL_T VARCHAR(200)
  962. GRILLE_T_EVOL_P VARCHAR(200)
  963. GRILLE_T_DETAIL_P VARCHAR(200)
  964. USB_DIR VARCHAR(200)
  965. USB_DISK VARCHAR(50)
  966. USB_SENS INTEGER
  967. USB_MODE INTEGER
  968. USB_ONLY BIT
  969. USB_DATA BIT
  970. USB_SAVE BIT
  971. USB_EXE BIT
  972. USB_VALEURS BIT
  973. USB_MEROPS BIT
  974. USB_LNK BIT
  975. USB_FILE BIT
  976. FORMATION_START BIT
  977. IMPORT_OP_FILE VARCHAR(255)
  978. IMPORT_OP_LIQUIDITE BIT
  979. URL2 VARCHAR(255)
  980. URL3 VARCHAR(255)
  981. URL4 VARCHAR(255)
  982. URL5 VARCHAR(255)
  983. SAVE_EXPORT_SORT BIT
  984. SAVE_EXPORT_CLOSE BIT
  985. LIB_ZONE1 VARCHAR(25)
  986. LIB_ZONE2 VARCHAR(25)
  987. LIB_ZONE3 VARCHAR(25)
  988. LIB_ZONE4 VARCHAR(25)
  989. LIB_ZONE5 VARCHAR(25)
  990. LIB_ZONE6 VARCHAR(25)
  991. LIB_ZONE7 VARCHAR(25)
  992. LIB_ZONE8 VARCHAR(25)
  993. LIB_ZONEO1 VARCHAR(25)
  994. LIB_ZONEO2 VARCHAR(25)
  995. LIB_ZONEO3 VARCHAR(25)
  996. LIB_ZONEO4 VARCHAR(25)
  997. LIB_ZONEO5 VARCHAR(25)
  998. LIB_ZONEO6 VARCHAR(25)
  999. LIB_ZONEO7 VARCHAR(25)
  1000. LIB_ZONEO8 VARCHAR(25)
  1001. LIB_ZONEC1 VARCHAR(25)
  1002. LIB_ZONEC2 VARCHAR(25)
  1003. LIB_ZONEC3 VARCHAR(25)
  1004. LIB_ZONEC4 VARCHAR(25)
  1005. LIB_ZONEC5 VARCHAR(25)
  1006. LIB_ZONEC6 VARCHAR(25)
  1007. LIB_ZONEC7 VARCHAR(25)
  1008. LIB_ZONEC8 VARCHAR(25)
  1009. PALMARES_TITRE BIT
  1010. PALMARES_FILTRE INTEGER
  1011. ID_PHOTO_SEL INTEGER
  1012. SEE_STAT_VAL1 INTEGER
  1013. SEE_STAT_VAL2 INTEGER
  1014. SEE_STAT_VAL3 INTEGER
  1015. SEE_STAT_VAL4 INTEGER
  1016. SEE_ONLY_OBJ_STOP BIT
  1017. SAVE_DATA BIT
  1018. CALCUL_QTE_ENTIER BIT
  1019. TASK_ALERTS BIT
  1020. COMP_DEVISE1 BIT
  1021. COMP_DEVISE2 BIT
  1022. ID_TAILLE_SEL INTEGER
  1023. LIB_DIVERS4 VARCHAR(25)
  1024. LIB_DIVERS5 VARCHAR(25)
  1025. COPY_MAJ_LIQ BIT
  1026. LIB_DIVERSO4 VARCHAR(25)
  1027. LIB_DIVERSO5 VARCHAR(25)
  1028. IS_TRANSPARENT BIT
  1029. SPLITTER_VALO INTEGER
  1030. SUP_OT_YEAR INTEGER
  1031. LINE_CROIX INTEGER
  1032. POINT_CROIX BIT
  1033. LINE_COURBE INTEGER
  1034. INDEX_GRAPH_HISTO INTEGER
  1035. TAB_GRAPH_HISTO INTEGER
  1036. MODE_GRAPH_HISTO INTEGER
  1037. MODE2_GRAPH_HISTO INTEGER
  1038. TRI_GRAPH_HISTO INTEGER
  1039. PALETTE_GRAPH_HISTO INTEGER
  1040. LIQ_GRAPH_HISTO BIT
  1041. DATE_GRAPH_HISTO DATE
  1042. GRILLE_T_PERF_ASC_SORT BIT
  1043. GRILLE_T_PERF_ID_SORT INTEGER
  1044. MAIN_SORT_DISTINCT BIT
  1045. MAIN_SORT_ID1 INTEGER
  1046. MAIN_SORT_ID2 INTEGER
  1047. MAIN_SORT_ID3 INTEGER
  1048. MAIN_SORT_ID4 INTEGER
  1049. MAIN_SORT_ASC1 BIT
  1050. MAIN_SORT_ASC2 BIT
  1051. MAIN_SORT_ASC3 BIT
  1052. MAIN_SORT_ASC4 BIT
  1053. IMPORT_RAPPEL_FILE VARCHAR(255)
  1054. IMPORT_RAPPEL_SEPARATOR VARCHAR(5)
  1055. IMPORT_RAPPEL_DATE_FORMAT INTEGER
  1056. IMPORT_RAPPEL_DATE INTEGER
  1057. IMPORT_RAPPEL_COMMENT INTEGER
  1058. IMPORT_RAPPEL_COMMENT2 INTEGER
  1059. COMP_GRAPH_HISTO INTEGER
  1060. COMP_COURBE_GRAPH_HISTO BIT
  1061. PURGE_SAVE_MOIS INTEGER
  1062. SEE_SOLDER BIT
  1063. DIVIDENDE_NET_BRUT INTEGER
  1064. PURGE_SAVE_MOIS_TASK INTEGER
  1065. IMPORT_LONDRES_100 BIT
  1066. HISTO_COURS_SUPPL BIT
  1067. NB_SEANCE INTEGER
  1068. MONEY_PERF_01JANV BIT
  1069. MONEY_PERF_INVEST BIT
  1070. MONEY_NO_LIQ BIT
  1071. PROXY_DESACTIVE_FILE VARCHAR(250)
  1072. MAX_DETAIL_FUSION INTEGER
  1073. SEE_MSG_FUSION BIT
  1074. MONEY_PERF_SEE_MT BIT
  1075. MONEY_PERF_VEILLE BIT
  1076. MONEY_PERF_INDEX INTEGER
  1077. MONEY_PERF_DATE DATE
  1078. SEE_EVOL_01SEM BIT
  1079. SEE_EVOL_01MOIS BIT
  1080. MONEY_PERF_DATEB BIT
  1081. ORDER_WAIT_REVOCATION BIT
  1082. PRINT_COURS_SAISI BIT
  1083. ###TABLE_DATA_PREFERENCE
  1084. 1|0|0|0|0|0|1|0|0|1|http://www.abcbourse.com/Graphes/display.aspx?s=<--ISIN--><--PLACE-->|||0||||;|1|2|6|3|4|5|7|&0&|166|50|55|125|70|65|55|125|70|65|55|55|58|70|125|70|0|65|57|75|55|55|55|Verdana|8|1|3|0|1|0|1|0|0.3|0.15|7830|610|1|1|1|1|0|55|55|55|55|55|55|55|55|55|55|55|55|55|55|55|55|100|55|55|145|85|75|55|200|55|55|55|125|70|0|1|2|3|99|99|4|5|99|99|99|6|7|99|8|99|99|9|10|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|99|0|5|3|982|600|2|0|1000|600|2|0|1000|600|2|0|1000|600|2|0|1000|600|30|0|5|5|5|1|125|99|70|99|55|99|55|99|75|99|55|99|55|99|55|99|75|99|55|99|A:\|0|2|2005/01/01|2|0|1|1|-1|-1|1000|630|16774620|0|0|0|40|0|1|0|1|0|3|0|0|0|1|0|1|1|2014/12/16|0|2014/12/16|1|2002/01/01|70|99|70|99|55|99|55|99|35|99|200|99|24|99|24|99|24|99|24|99|1950/01/01|0|-1|1899/12/30|0|90|0|0|0|0|0|0|1|A:\|0|0|1|2||1|1|1|1|0|4||24|99|24|99|24|99|200|99|200|99|55|99|55|99|24|99|55|99|55|99|0|99|0|99|0|99|0|99|0|99|0|99|0|99|0|99|0|99|0|99|2|1|0|0|0|0|TRAINDDEVLOOWAIORIDIVLIQ|0|0|200&90&90&90&90&55&90&90&90&90&90&90&90&90&90&90&90&90&90&90|1|1|1|1||<--PORTEFEUILLE--> AU <--DATE--><BR><--ETAT--><BR>DU <--DATE_DEBUT--> AU <--DATE_FIN-->|Divers|0|1|1950/01/01|0|-1|0|1|Achat|Vente|Frais / OpΘrat.|Performance|1|1|Divers2|Divers3|Divers|Divers2|Divers3|0|153000|15666|0|0.15|610|0|0||-5||1|1|1|1|1|1|0|0|calc.exe|0|0|1|0|Obj / Loss|0|0|5|0|0|0|1|0|0|0|0|5000|0|1|1|1|1|1|0|0|1||||8|0|0|1|0|0|0|SUP|Euro / Devise de votre choix "Ecran PrΘfΘrences"|SUP|0|0|0|0|0|0|1|2007/01/01||;|0|0|-1|-1|0|-1|-1|-1|-1|-1|-1|-1|-1|0|0||||0|1|1|1|0|0|0|1|0|1|3|0|0|1|0|0|0|0|0|0|0|1|1|-1|1|2007/12/31|2008/01/26|0|0|0||0|2008/01/01|0||0|0|1|1|1|0|0|1|1|1|0|0|1|0|1|NNNNNNNNNNNNNNNNNNNN|2|1|1|1|1|1|120|2000/01/01|0|0|1|150|0||||0|0|0|4|1|0|0|1|1|1|1|1|1|1|0|0|0|0|1|2|1|1|0|0|0|0|0|2|2|3|4|0|0|0|0|0|50|0|0|175&75&|90&90&100&80&|80&150&100&100&|150&140&150&150&80&80&80&80&|250&|MΘrops||0|0|1|1|1|1|1|1|1|0|1||0|||||0|0|DonnΘe  1|DonnΘe  2|DonnΘe  3|DonnΘe  4|DonnΘe  5|DonnΘe  6|DonnΘe  7|DonnΘe  8|DonnΘe  1|DonnΘe  2|DonnΘe  3|DonnΘe  4|DonnΘe  5|DonnΘe  6|DonnΘe  7|DonnΘe  8|DonnΘe  1|DonnΘe  2|DonnΘe  3|DonnΘe  4|DonnΘe  5|DonnΘe  6|DonnΘe  7|DonnΘe  8|1|0|1|0|0|0|130|0|1|1|1|0|0|1|Divers4|Divers5|1|Divers4|Divers5|0|281|0|1|1|2|2|0|0|1|0|0|0|1980/01/01|0|0|0|0|0|0|0|1|1|1|1||;|0|-1|-1|-1|0|0|1200|0|0|1200|0|1|10|1|1|0||10|1|0|1|0|1899/12/30|0|0|1|0|0|
  1085. ###TABLE_STRUCT_VALORISATION
  1086. ID_ORIGINE SMALLINT
  1087. DATE_VALORISATION DATE
  1088. PRIX_VALORISATION CURRENCY
  1089. ###TABLE_DATA_VALORISATION
  1090. ###TABLE_STRUCT_VERSION
  1091. ID_VERSION VARCHAR(5)
  1092. ###TABLE_DATA_VERSION
  1093. 9.067|
  1094. ###TABLE_STRUCT_FAMILLE
  1095. ID INTEGER AUTO_INCREMENT='1'
  1096. LIBELLE VARCHAR(255)
  1097. ALL_ORIGINE VARCHAR(10000)
  1098. NOM VARCHAR(100)
  1099. COMMENT1 VARCHAR(100)
  1100. COMMENT2 VARCHAR(100)
  1101. COMMENT3 VARCHAR(100)
  1102. COMMENT4 VARCHAR(100)
  1103. COMMENT5 VARCHAR(100)
  1104. COMMENT6 VARCHAR(100)
  1105. COMMENT7 VARCHAR(100)
  1106. COMMENT8 VARCHAR(100)
  1107. SEE_ORIGINE BIT
  1108. SEE_GROUPE BIT
  1109. ###TABLE_DATA_FAMILLE
  1110. ###TABLE_STRUCT_INDICATEUR
  1111. ID INTEGER AUTO_INCREMENT='37'
  1112. TYPE INTEGER
  1113. PARAM1 CURRENCY
  1114. PARAM2 CURRENCY
  1115. PARAM3 CURRENCY
  1116. ###TABLE_DATA_INDICATEUR
  1117. 1|1|10|0|0|
  1118. 2|1|20|0|0|
  1119. 3|1|50|0|0|
  1120. 4|1|100|0|0|
  1121. 5|1|200|0|0|
  1122. 6|3|9|0|0|
  1123. 7|3|14|0|0|
  1124. 8|3|25|0|0|
  1125. 9|4|9|0|0|
  1126. 10|4|14|0|0|
  1127. 11|4|25|0|0|
  1128. 12|5|0|0|0|
  1129. 13|6|0|0|0|
  1130. 14|7|0|0|0|
  1131. 15|8|12|0|0|
  1132. 16|14|12|0|0|
  1133. 17|10|0|0|0|
  1134. 18|11|12.3333|25.6666|9|
  1135. 19|9|0|0|0|
  1136. 20|12|9|0|0|
  1137. 21|12|14|0|0|
  1138. 22|12|25|0|0|
  1139. 23|13|8|0|0|
  1140. 24|13|14|0|0|
  1141. 25|13|24|0|0|
  1142. 26|15|10|0|0|
  1143. 27|15|20|0|0|
  1144. 28|15|50|0|0|
  1145. 29|16|5|0|0|
  1146. 30|17|5|10|0|
  1147. 31|18|5|10|0|
  1148. 32|19|25|3|0|
  1149. 33|21|14|0|0|
  1150. 34|22|20|5|0|
  1151. 35|20|20|0|0|
  1152. 36|28|0|0|0|
  1153. ###TABLE_STRUCT_FRAIS
  1154. ID_FRAIS INTEGER AUTO_INCREMENT='2'
  1155. ID_ORIGINE INTEGER
  1156. LIB_FRAIS VARCHAR(50)
  1157. MONTANT1 CURRENCY
  1158. MONTANT2 CURRENCY
  1159. FRAIS1 CURRENCY
  1160. FRAIS2 CURRENCY
  1161. FRAIS3 CURRENCY
  1162. FRAIS_1_TYPE INTEGER
  1163. FRAIS_2_TYPE INTEGER
  1164. FRAIS_3_TYPE INTEGER
  1165. TVA_CODE VARCHAR(10)
  1166. ISHT BIT
  1167. FRAIS_MIN CURRENCY
  1168. IMPOT_BOURSE BIT
  1169. ORDER INTEGER
  1170. FRAIS_FIXE CURRENCY
  1171. FRAIS_MIN1 CURRENCY
  1172. FRAIS_MIN2 CURRENCY
  1173. FRAIS_MIN3 CURRENCY
  1174. MONTANT3 CURRENCY
  1175. MONTANT4 CURRENCY
  1176. FRAIS4 CURRENCY
  1177. FRAIS_4_TYPE INTEGER
  1178. FRAIS_MIN4 CURRENCY
  1179. MONTANT5 CURRENCY
  1180. FRAIS5 CURRENCY
  1181. FRAIS_5_TYPE INTEGER
  1182. FRAIS_MIN5 CURRENCY
  1183. FRAIS_DEVISE_ORIGINE BIT
  1184. FRAIS_PART CURRENCY
  1185. ###TABLE_DATA_FRAIS
  1186. ###TABLE_STRUCT_FISCALITE
  1187. YEAR_FISCALITE INTEGER
  1188. SEUIL CURRENCY
  1189. TAUX CURRENCY
  1190. WARRANT BIT
  1191. ###TABLE_DATA_FISCALITE
  1192. 1996|30489.8|26|0|
  1193. 1997|15244.9|26|0|
  1194. 1998|7622.46|26|0|
  1195. 2001|7623|26|0|
  1196. 2002|7650|26|0|
  1197. 2003|15000|26|0|
  1198. 2005|15000|27|0|
  1199. 1999|0|26|1|
  1200. 2005|0|27|1|
  1201. 2011|0|31.3|1|
  1202. 2007|20000|27|0|
  1203. 2009|25730|30.1|0|
  1204. 2010|25830|30.1|0|
  1205. 2011|0|31.3|0|
  1206. ###TABLE_STRUCT_SCREEN
  1207. ID_SCREEN VARCHAR(50)
  1208. SCREEN_LEFT INTEGER
  1209. SCREEN_TOP INTEGER
  1210. SCREEN_WIDTH INTEGER
  1211. SCREEN_HEIGHT INTEGER
  1212. ID_PHOTO INTEGER
  1213. ###TABLE_DATA_SCREEN
  1214. TMAINFORM|0|0|0|0|1|
  1215. TFRMMAIN|4|11|979|502|1|
  1216. ###TABLE_STRUCT_TASK
  1217. ID_TASK INTEGER INTEGER AUTO_INCREMENT='1'
  1218. DATE_CREATE DATETIME
  1219. TYPE_TASK INTEGER
  1220. TYPE_FREQUENCE INTEGER
  1221. DATE_NEXT_TASK DATETIME
  1222. DATE_LAST_TASK DATETIME
  1223. DIR_PARAM VARCHAR(255)
  1224. FREQUENCE_PARAM INTEGER
  1225. COMMENT VARCHAR(2000)
  1226. ACTIVE BIT
  1227. AUTO_CLOSE BIT
  1228. PLAGE_START VARCHAR(5)
  1229. PLAGE_END VARCHAR(5)
  1230. ID_ORIGINE INTEGER
  1231. MONTANT CURRENCY
  1232. TYPE_OPERATION INTEGER
  1233. FORMAT_FILE_SAVE INTEGER
  1234. ###TABLE_DATA_TASK
  1235. ###TABLE_STRUCT_MARQUEUR
  1236. ID_MARQUEUR INTEGER INTEGER AUTO_INCREMENT='1'
  1237. LIB_MARQUEUR VARCHAR(50)
  1238. ID_MARQUEUR_PERE INTEGER
  1239. ###TABLE_DATA_MARQUEUR
  1240. ###TABLE_STRUCT_ATTACHMENT
  1241. ID INTEGER
  1242. NOM VARCHAR(255)
  1243. CODE VARCHAR(20)
  1244. PLACE VARCHAR(5)
  1245. TYPE_SUPPORT INTEGER
  1246. ###TABLE_DATA_ATTACHMENT
  1247. ###TABLE_STRUCT_WAIT
  1248. ID_WAIT INTEGER INTEGER AUTO_INCREMENT='1'
  1249. CODE VARCHAR(20)
  1250. PLACE VARCHAR(5)
  1251. NOM VARCHAR(100)
  1252. QUANTITE CURRENCY
  1253. ID_ORIGINE SMALLINT
  1254. TYPE SMALLINT
  1255. SENS SMALLINT
  1256. DATE_ORDRE DATE
  1257. PRIX_LIMITE CURRENCY
  1258. DATE_LIMITE DATE
  1259. PRIX_COURS CURRENCY
  1260. VARIATION CURRENCY
  1261. DATE_COURS DATETIME
  1262. PRIX_OPEN CURRENCY
  1263. PRIX_BAS CURRENCY
  1264. PRIX_HAUT CURRENCY
  1265. VOLUME CURRENCY
  1266. ID_FRAIS INTEGER
  1267. COMMENT VARCHAR(100)
  1268. STOP_LOSS CURRENCY
  1269. OBJECTIF CURRENCY
  1270. ID_DEVISE INTEGER
  1271. REVOCATION BIT
  1272. ###TABLE_DATA_WAIT
  1273. ###TABLE_STRUCT_WAITPOSTIT
  1274. ID_WAIT INTEGER
  1275. COLOR INTEGER
  1276. POSTIT VARCHAR(2000)
  1277. ###TABLE_DATA_WAITPOSTIT
  1278. ###TABLE_STRUCT_LOOK_CATEGORY
  1279. ID_LOOK_CATEGORY INTEGER INTEGER AUTO_INCREMENT='1'
  1280. LIB_LOOK_CATEGORY VARCHAR(50)
  1281. ###TABLE_DATA_LOOK_CATEGORY
  1282. ###TABLE_STRUCT_GRILLE
  1283. ID_GRILLE INTEGER
  1284. ID_SORT INTEGER
  1285. ASC_SORT BIT
  1286. COL_ID_0 INTEGER
  1287. COL_WIDTH_0 INTEGER
  1288. COL_ID_1 INTEGER
  1289. COL_WIDTH_1 INTEGER
  1290. COL_ID_2 INTEGER
  1291. COL_WIDTH_2 INTEGER
  1292. COL_ID_3 INTEGER
  1293. COL_WIDTH_3 INTEGER
  1294. COL_ID_4 INTEGER
  1295. COL_WIDTH_4 INTEGER
  1296. COL_ID_5 INTEGER
  1297. COL_WIDTH_5 INTEGER
  1298. COL_ID_6 INTEGER
  1299. COL_WIDTH_6 INTEGER
  1300. COL_ID_7 INTEGER
  1301. COL_WIDTH_7 INTEGER
  1302. COL_ID_8 INTEGER
  1303. COL_WIDTH_8 INTEGER
  1304. COL_ID_9 INTEGER
  1305. COL_WIDTH_9 INTEGER
  1306. COL_ID_10 INTEGER
  1307. COL_WIDTH_10 INTEGER
  1308. COL_ID_11 INTEGER
  1309. COL_WIDTH_11 INTEGER
  1310. COL_ID_12 INTEGER
  1311. COL_WIDTH_12 INTEGER
  1312. COL_ID_13 INTEGER
  1313. COL_WIDTH_13 INTEGER
  1314. COL_ID_14 INTEGER
  1315. COL_WIDTH_14 INTEGER
  1316. COL_ID_15 INTEGER
  1317. COL_WIDTH_15 INTEGER
  1318. COL_ID_16 INTEGER
  1319. COL_WIDTH_16 INTEGER
  1320. COL_ID_17 INTEGER
  1321. COL_WIDTH_17 INTEGER
  1322. COL_ID_18 INTEGER
  1323. COL_WIDTH_18 INTEGER
  1324. COL_ID_19 INTEGER
  1325. COL_WIDTH_19 INTEGER
  1326. COL_ID_20 INTEGER
  1327. COL_WIDTH_20 INTEGER
  1328. COL_ID_21 INTEGER
  1329. COL_WIDTH_21 INTEGER
  1330. COL_ID_22 INTEGER
  1331. COL_WIDTH_22 INTEGER
  1332. COL_ID_23 INTEGER
  1333. COL_WIDTH_23 INTEGER
  1334. COL_ID_24 INTEGER
  1335. COL_WIDTH_24 INTEGER
  1336. COL_ID_25 INTEGER
  1337. COL_WIDTH_25 INTEGER
  1338. COL_ID_26 INTEGER
  1339. COL_WIDTH_26 INTEGER
  1340. COL_ID_27 INTEGER
  1341. COL_WIDTH_27 INTEGER
  1342. COL_ID_28 INTEGER
  1343. COL_WIDTH_28 INTEGER
  1344. COL_ID_29 INTEGER
  1345. COL_WIDTH_29 INTEGER
  1346. ID_VUE INTEGER
  1347. LIB_VUE VARCHAR(50)
  1348. VUE_DEFAUT BIT
  1349. ###TABLE_DATA_GRILLE
  1350. 0|48|0|0|162|1|50|2|55|48|130|6|55|50|130|11|55|12|58|14|125|17|57|18|50|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1351. 1|0|1|0|150|1|75|2|75|3|75|4|75|5|75|6|75|8|75|9|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1352. 2|0|1|0|150|1|75|2|75|3|125|4|75|5|75|6|75|7|75|8|75|9|75|10|75|11|75|12|75|13|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1353. 3|0|1|0|150|1|125|2|55|3|125|4|55|5|125|6|125|7|65|8|220|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1354. 4|0|1|0|150|1|50|2|125|3|55|5|65|6|55|7|65|8|75|9|75|10|75|11|220|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1355. 5|0|1|0|150|1|50|2|125|3|125|4|125|5|75|6|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1356. 6|0|0|0|65|1|150|2|150|3|75|4|220|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1357. 7|2|1|2|100|19|75|14|75|13|75|15|75|16|75|20|75|17|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1358. 8|0|0|0|65|1|75|2|150|3|220|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1359. 9|0|0|0|85|1|210|2|150|4|220|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1360. 10|1|1|0|115|1|240|2|105|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1361. 11|-1|0|0|120|1|160|2|75|3|75|4|75|5|75|6|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1362. 12|-1|0|0|85|1|288|2|75|3|75|4|75|5|75|6|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1363. 13|2|1|2|150|3|55|4|75|5|55|6|85|7|75|8|75|9|75|10|75|11|75|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1364. 14|2|1|22|0|1|0|2|0|3|0|9|0|10|0|11|0|5|0|6|0|7|0|8|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1365. 15|0|1|0|0|1|0|3|0|2|0|4|0|5|0|6|0|7|0|8|0|9|0|10|0|11|0|12|0|13|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1366. 16|0|1|0|0|1|0|2|0|3|0|4|0|5|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|-1|0|0|Standard|1|
  1367. ###TABLE_STRUCT_CLUB
  1368. NOM VARCHAR(100)
  1369. ID_ORIGINE INTEGER
  1370. ADRESSE1 VARCHAR(200)
  1371. ADRESSE2 VARCHAR(200)
  1372. CODE_POSTAL VARCHAR(10)
  1373. VILLE VARCHAR(50)
  1374. TEL VARCHAR(20)
  1375. FAX VARCHAR(20)
  1376. EMAIL VARCHAR(100)
  1377. DATE_START DATE
  1378. DATE_END DATE
  1379. VERSEMENT_MENSUEL CURRENCY
  1380. PRIX_PART_INITIALE CURRENCY
  1381. BQ_BANQUE VARCHAR(100)
  1382. BQ_NOM VARCHAR(100)
  1383. BQ_PRENOM VARCHAR(100)
  1384. BQ_COMPTE VARCHAR(200)
  1385. BQ_ADRESSE1 VARCHAR(200)
  1386. BQ_ADRESSE2 VARCHAR(200)
  1387. BQ_CODE_POSTAL VARCHAR(10)
  1388. BQ_VILLE VARCHAR(50)
  1389. BQ_TEL VARCHAR(20)
  1390. BQ_FAX VARCHAR(20)
  1391. BQ_EMAIL VARCHAR(100)
  1392. COMMENT VARCHAR(5000)
  1393. ###TABLE_DATA_CLUB
  1394. ###TABLE_STRUCT_MEMBER
  1395. ID_MEMBER INTEGER INTEGER AUTO_INCREMENT='1'
  1396. NOM VARCHAR(50)
  1397. PRENOM VARCHAR(50)
  1398. ID_FONCTION INTEGER
  1399. ADRESSE1 VARCHAR(200)
  1400. ADRESSE2 VARCHAR(200)
  1401. CODE_POSTAL VARCHAR(10)
  1402. VILLE VARCHAR(50)
  1403. TEL VARCHAR(20)
  1404. FAX VARCHAR(20)
  1405. EMAIL VARCHAR(100)
  1406. DATE_START DATE
  1407. DATE_END DATE
  1408. COMMENT VARCHAR(5000)
  1409. ###TABLE_DATA_MEMBER
  1410. ###TABLE_STRUCT_CLOTURE
  1411. DATE_CLOTURE DATE
  1412. PRIX_CLOTURE CURRENCY
  1413. ###TABLE_DATA_CLOTURE
  1414. ###TABLE_STRUCT_INTERCEPTEUR
  1415. CODE VARCHAR(20)
  1416. COEFFICIENT CURRENCY
  1417. ###TABLE_DATA_INTERCEPTEUR
  1418. ###TABLE_STRUCT_FISCALITE_DIVIDENDE
  1419. YEAR_FISCALITE INTEGER
  1420. ABATTEMENT_TAUX CURRENCY
  1421. ABATTEMENT_FORFAIT CURRENCY
  1422. IMPOT_TAUX CURRENCY
  1423. IMPOT_PLAFOND CURRENCY
  1424. REVENU_TAUX CURRENCY
  1425. ###TABLE_DATA_FISCALITE_DIVIDENDE
  1426. 2005|50|2440|50|230|20|
  1427. 2006|40|3050|50|230|20|
  1428. ###TABLE_STRUCT_NEWS_RSS
  1429. ID_RSS INTEGER INTEGER AUTO_INCREMENT='4'
  1430. LIB_RSS VARCHAR(50)
  1431. URL_RSS VARCHAR(255)
  1432. ###TABLE_DATA_NEWS_RSS
  1433. 1|AbcBourse - Informations Θconomiques et financiΦre|http://www.abcbourse.com/RSS/displaynewsrss.aspx|
  1434. 2|AbcBourse - Analyses|http://www.abcbourse.com/RSS/lastanalysisrss.aspx|
  1435. 3|Les Echos - Finance|http://syndication.lesechos.fr/rss/rss_finance.xml|
  1436. ###TABLE_STRUCT_MASSE_GLOBAL
  1437. ID_MASSE INTEGER INTEGER AUTO_INCREMENT='1'
  1438. CODE_MASSE VARCHAR(20)
  1439. PLACE_MASSE VARCHAR(5)
  1440. NOM_MASSE VARCHAR(100)
  1441. TYPE_MASSE INTEGER
  1442. PRIX_MASSE CURRENCY
  1443. DATE_MASSE DATE
  1444. QUANTITE_MASSE CURRENCY
  1445. OBJECTIF_MASSE CURRENCY
  1446. ALERT_MIN_MASSE CURRENCY
  1447. ALERT_MAX_MASSE CURRENCY
  1448. ALL_ORIGINE VARCHAR(1000)
  1449. COMMENT VARCHAR(100)
  1450. DATE_CREATE DATETIME
  1451. ID_DEVISE INTEGER
  1452. IS_FRAIS_FORCE BIT
  1453. FRAIS_FORCE CURRENCY
  1454. COMMENT_ACHAT VARCHAR(100)
  1455. COMMENT_VENTE VARCHAR(100)
  1456. ACTIVE BIT
  1457. ID_MASSE_OLD INTEGER
  1458. LIQUIDITE_RETRO BIT
  1459. ###TABLE_DATA_MASSE_GLOBAL
  1460. ###TABLE_STRUCT_MASSE_DETAIL
  1461. ID_MASSE INTEGER
  1462. ID_ORIGINE INTEGER
  1463. ID_ACTION INTEGER
  1464. QUANTITE CURRENCY
  1465. LIQUIDITE CURRENCY
  1466. ID_PARTIELLE INTEGER
  1467. ###TABLE_DATA_MASSE_DETAIL
  1468. ###TABLE_STRUCT_STYLE
  1469. ID_STYLE VARCHAR(20)
  1470. LIB_STYLE VARCHAR(50)
  1471. FONT_NAME VARCHAR(30)
  1472. FONT_SIZE INTEGER
  1473. FONT_COLOR VARCHAR(6)
  1474. BACK_COLOR VARCHAR(6)
  1475. FONT_WEIGHT VARCHAR(10)
  1476. FONT_STYLE VARCHAR(10)
  1477. ID INTEGER
  1478. ###TABLE_DATA_STYLE
  1479. title|Titre|arial|9|000000|EEEEEE|bold;||1|
  1480. titleTable|EntΩte tableau|arial|8|000000|EEEEEE|bold;||1|
  1481. text|Texte tableau|arial|8|000000|FFFFFF|||1|
  1482. text2|Texte tableau (ligne paire / Θdition Pro)|arial|8|000000|FFFFFF|||1|
  1483. section|Texte rubrique (Θdition Pro)|arial|8|000000|FFFFFF|||1|
  1484. total|Texte tableau (ligne de total / Θdition Pro)|arial|8|000000|FFFFFF|||1|
  1485. ###TABLE_STRUCT_MASSE_OP_GLOBAL
  1486. ID_MASSE INTEGER INTEGER AUTO_INCREMENT='1'
  1487. TYPE_MASSE INTEGER
  1488. DATE_MASSE DATE
  1489. DATE_CREATE DATETIME
  1490. ALL_ORIGINE VARCHAR(1000)
  1491. COMMENT VARCHAR(100)
  1492. ###TABLE_DATA_MASSE_OP_GLOBAL
  1493. ###TABLE_STRUCT_MASSE_OP_DETAIL
  1494. ID_MASSE INTEGER
  1495. ID_ORIGINE INTEGER
  1496. ID_LIQUIDITE INTEGER
  1497. MONTANT CURRENCY
  1498. ###TABLE_DATA_MASSE_OP_DETAIL
  1499. ###TABLE_STRUCT_MARQUEUR_ORIGINE
  1500. ID_MARQUEUR_ORIGINE INTEGER INTEGER AUTO_INCREMENT='1'
  1501. LIB_MARQUEUR_ORIGINE VARCHAR(50)
  1502. ID_MARQUEUR_ORIGINE_PERE INTEGER
  1503. ###TABLE_DATA_MARQUEUR_ORIGINE
  1504. ###TABLE_STRUCT_MASSE_OT_GLOBAL
  1505. ID_MASSE INTEGER INTEGER AUTO_INCREMENT='1'
  1506. TYPE_MASSE INTEGER
  1507. DATE_MASSE DATE
  1508. DATE_CREATE DATETIME
  1509. CODE VARCHAR(20)
  1510. PLACE VARCHAR(5)
  1511. NOM VARCHAR(50)
  1512. ALL_ORIGINE VARCHAR(1000)
  1513. TYPE_ACTION INTEGER
  1514. SEE_FUSION BIT
  1515. COMMENT VARCHAR(100)
  1516. ###TABLE_DATA_MASSE_OT_GLOBAL
  1517. ###TABLE_STRUCT_COMPARATEUR
  1518. ID INTEGER INTEGER AUTO_INCREMENT='1'
  1519. LIBELLE VARCHAR(30)
  1520. ###TABLE_DATA_COMPARATEUR
  1521. ###TABLE_STRUCT_COMPARATEUR_VALEUR
  1522. ID INTEGER
  1523. CODE VARCHAR(20)
  1524. PLACE VARCHAR(5)
  1525. ###TABLE_DATA_COMPARATEUR_VALEUR
  1526. ###TABLE_STRUCT_ORIGINEPOSTIT
  1527. ID_ORIGINE INTEGER
  1528. POSTIT VARCHAR(2000)
  1529. COLOR INTEGER
  1530. ###TABLE_DATA_ORIGINEPOSTIT
  1531. ###TABLE_STRUCT_COMMENT
  1532. ID INTEGER
  1533. CODE VARCHAR(20)
  1534. PLACE VARCHAR(5)
  1535. DATE DATE
  1536. COMMENT VARCHAR(100)
  1537. TYPE_SUPPORT INTEGER
  1538. ###TABLE_DATA_COMMENT
  1539. ###TABLE_STRUCT_PROHISTO
  1540. ID INTEGER
  1541. CODE VARCHAR(20)
  1542. PLACE VARCHAR(5)
  1543. NOM VARCHAR(100)
  1544. ###TABLE_DATA_PROHISTO
  1545. ###TABLE_STRUCT_HINT
  1546. ID INTEGER
  1547. POSITION INTEGER
  1548. ###TABLE_DATA_HINT
  1549. ###TABLE_STRUCT_PREFERENCE_PRO
  1550. CFG_DEVISE INTEGER
  1551. CFG_TAUX INTEGER
  1552. CFG_RP_LIQ INTEGER
  1553. CFG_COL_ALIGN INTEGER
  1554. CFG_NB_LIGNE INTEGER
  1555. CFG_NB_LIGNE_T INTEGER
  1556. CFG_HEAD_ORDRE INTEGER
  1557. CFG_PTF_ORDRE INTEGER
  1558. CFG_TRAN_ORDRE INTEGER
  1559. CFG_RPVAL_ORDRE INTEGER
  1560. CFG_RPVAL_GRAPH_ORDRE INTEGER
  1561. CFG_SOLDEE_ORDRE INTEGER
  1562. CFG_OP_ORDRE INTEGER
  1563. CFG_FOOT_ORDRE INTEGER
  1564. LOGO_FILE VARCHAR(255)
  1565. LOGO_ALIGN INTEGER
  1566. LOGO_WITH_TEXT BIT
  1567. HEAD_TEXT VARCHAR(10000)
  1568. HEAD_ALIGN INTEGER
  1569. FOOT_TEXT VARCHAR(10000)
  1570. FOOT_ALIGN INTEGER
  1571. PTF_TEXT VARCHAR(1000)
  1572. PTF_ALIGN INTEGER
  1573. PTF_LIG_LIQUIDITE VARCHAR(50)
  1574. PTF_LIG_LIQUIDITE_ORDRE INTEGER
  1575. PTF_LIG_TITRE_ENCOURS VARCHAR(50)
  1576. PTF_LIG_TITRE_ENCOURS_ORDRE INTEGER
  1577. PTF_LIG_VALORISATION VARCHAR(50)
  1578. PTF_LIG_VALORISATION_ORDRE INTEGER
  1579. PTF_LIG_PERFORMANCE_ENCOURS VARCHAR(50)
  1580. PTF_LIG_PERFORMANCE_ENCOURS_ORDRE INTEGER
  1581. PTF_LIG_PERFORMANCE VARCHAR(50)
  1582. PTF_LIG_PERFORMANCE_ORDRE INTEGER
  1583. PTF_LIG_APPORT VARCHAR(50)
  1584. PTF_LIG_APPORT_ORDRE INTEGER
  1585. PTF_LIG_RETRAIT VARCHAR(50)
  1586. PTF_LIG_RETRAIT_ORDRE INTEGER
  1587. PTF_COL_TITRE VARCHAR(50)
  1588. PTF_COL_TITRE_ORDRE INTEGER
  1589. PTF_COL_OLD VARCHAR(50)
  1590. PTF_COL_OLD_ORDRE INTEGER
  1591. PTF_COL_NEW VARCHAR(50)
  1592. PTF_COL_NEW_ORDRE INTEGER
  1593. PTF_COL_PERIODE VARCHAR(50)
  1594. PTF_COL_PERIODE_ORDRE INTEGER
  1595. TRAN_TEXT VARCHAR(1000)
  1596. TRAN_ALIGN INTEGER
  1597. TRAN_TRI INTEGER
  1598. TRAN_TRI_ASC BIT
  1599. TRAN_CODE VARCHAR(50)
  1600. TRAN_CODE_ORDRE INTEGER
  1601. TRAN_NOM VARCHAR(50)
  1602. TRAN_NOM_ORDRE INTEGER
  1603. TRAN_QUANTITE VARCHAR(50)
  1604. TRAN_QUANTITE_ORDRE INTEGER
  1605. TRAN_DATE VARCHAR(50)
  1606. TRAN_DATE_ORDRE INTEGER
  1607. TRAN_PRU VARCHAR(50)
  1608. TRAN_PRU_ORDRE INTEGER
  1609. TRAN_DATE_COURS VARCHAR(50)
  1610. TRAN_DATE_COURS_ORDRE INTEGER
  1611. TRAN_PRIX_COURS VARCHAR(50)
  1612. TRAN_PRIX_COURS_ORDRE INTEGER
  1613. TRAN_TOTAL_COURS VARCHAR(50)
  1614. TRAN_TOTAL_COURS_ORDRE INTEGER
  1615. TRAN_PERFORMANCE VARCHAR(50)
  1616. TRAN_PERFORMANCE_ORDRE INTEGER
  1617. TRAN_PERFORMANCE_TAUX VARCHAR(50)
  1618. TRAN_PERFORMANCE_TAUX_ORDRE INTEGER
  1619. RPVAL_TEXT VARCHAR(1000)
  1620. RPVAL_ALIGN INTEGER
  1621. RPVAL_TRI INTEGER
  1622. RPVAL_TRI_ASC BIT
  1623. RPVAL_CODE VARCHAR(50)
  1624. RPVAL_CODE_ORDRE INTEGER
  1625. RPVAL_NOM VARCHAR(50)
  1626. RPVAL_NOM_ORDRE INTEGER
  1627. RPVAL_TOTAL VARCHAR(50)
  1628. RPVAL_TOTAL_ORDRE INTEGER
  1629. RPVAL_TAUX VARCHAR(50)
  1630. RPVAL_TAUX_ORDRE INTEGER
  1631. RPVAL_GRAPH_TEXT VARCHAR(1000)
  1632. RPVAL_GRAPH_ALIGN INTEGER
  1633. RPVAL_GRAPH_TRI INTEGER
  1634. RPVAL_GRAPH_TRI_ASC BIT
  1635. RPVAL_GRAPH_TITLE VARCHAR(50)
  1636. RPVAL_GRAPH_ALIGN_G INTEGER
  1637. RPVAL_GRAPH_WIDTH INTEGER
  1638. RPVAL_GRAPH_HEIGHT INTEGER
  1639. RPVAL_GRAPH_LEGEND_C INTEGER
  1640. RPVAL_GRAPH_LEGEND INTEGER
  1641. RPVAL_GRAPH_FONT_TITLE VARCHAR(50)
  1642. RPVAL_GRAPH_SIZE_TITLE INTEGER
  1643. RPVAL_GRAPH_FONT VARCHAR(50)
  1644. RPVAL_GRAPH_SIZE INTEGER
  1645. RPVAL_GRAPH_BORDER INTEGER
  1646. OP_TEXT VARCHAR(1000)
  1647. OP_ALIGN INTEGER
  1648. OP_TRI INTEGER
  1649. OP_TRI_ASC BIT
  1650. OP_DATE VARCHAR(50)
  1651. OP_DATE_ORDRE INTEGER
  1652. OP_TYPE VARCHAR(50)
  1653. OP_TYPE_ORDRE INTEGER
  1654. OP_MONTANT VARCHAR(50)
  1655. OP_MONTANT_ORDRE INTEGER
  1656. OP_COMMENT VARCHAR(50)
  1657. OP_COMMENT_ORDRE INTEGER
  1658. OP_APPORT BIT
  1659. OP_RETRAIT BIT
  1660. OP_FRAIS_VERSEMENT BIT
  1661. OP_INTERET BIT
  1662. OP_FRAIS_SRD BIT
  1663. OP_FRAIS_GESTION BIT
  1664. OP_FRAIS_ENTREE BIT
  1665. OP_DROIT_GARDE BIT
  1666. OP_IMPOT BIT
  1667. OP_DIVERS1 BIT
  1668. OP_DIVERS2 BIT
  1669. OP_DIVERS3 BIT
  1670. SOLDEE_TEXT VARCHAR(1000)
  1671. SOLDEE_ALIGN INTEGER
  1672. SOLDEE_TRI INTEGER
  1673. SOLDEE_TRI_ASC BIT
  1674. SOLDEE_CODE VARCHAR(50)
  1675. SOLDEE_CODE_ORDRE INTEGER
  1676. SOLDEE_NOM VARCHAR(50)
  1677. SOLDEE_NOM_ORDRE INTEGER
  1678. SOLDEE_QUANTITE VARCHAR(50)
  1679. SOLDEE_QUANTITE_ORDRE INTEGER
  1680. SOLDEE_DATE VARCHAR(50)
  1681. SOLDEE_DATE_ORDRE INTEGER
  1682. SOLDEE_PRU VARCHAR(50)
  1683. SOLDEE_PRU_ORDRE INTEGER
  1684. SOLDEE_DATE_VENTE VARCHAR(50)
  1685. SOLDEE_DATE_VENTE_ORDRE INTEGER
  1686. SOLDEE_PRIX_VENTE VARCHAR(50)
  1687. SOLDEE_PRIX_VENTE_ORDRE INTEGER
  1688. SOLDEE_TOTAL_VENTE VARCHAR(50)
  1689. SOLDEE_TOTAL_VENTE_ORDRE INTEGER
  1690. SOLDEE_PERFORMANCE VARCHAR(50)
  1691. SOLDEE_PERFORMANCE_ORDRE INTEGER
  1692. SOLDEE_PERFORMANCE_TAUX VARCHAR(50)
  1693. SOLDEE_PERFORMANCE_TAUX_ORDRE INTEGER
  1694. TEXT1 VARCHAR(10000)
  1695. TEXT1_ALIGN INTEGER
  1696. TEXT2 VARCHAR(10000)
  1697. TEXT2_ALIGN INTEGER
  1698. TEXT3 VARCHAR(10000)
  1699. TEXT3_ALIGN INTEGER
  1700. CFG_TEXT1_ORDRE INTEGER
  1701. CFG_TEXT2_ORDRE INTEGER
  1702. CFG_TEXT3_ORDRE INTEGER
  1703. CFG_SOM_ORDRE INTEGER
  1704. SOM_TEXT VARCHAR(1000)
  1705. SOM_TEXT_ALIGN INTEGER
  1706. SOM_PTF VARCHAR(200)
  1707. SOM_TRAN VARCHAR(200)
  1708. SOM_RPVAL VARCHAR(200)
  1709. SOM_RPVAL_GRAPH VARCHAR(200)
  1710. SOM_SOLDEE VARCHAR(200)
  1711. SOM_OP VARCHAR(200)
  1712. SOM_TEXT1 VARCHAR(200)
  1713. SOM_TEXT2 VARCHAR(200)
  1714. SOM_TEXT3 VARCHAR(200)
  1715. CFG_DATE_START INTEGER
  1716. CFG_SEE_FUSION INTEGER
  1717. CFG_TYPE_NOM INTEGER
  1718. CFG_SAUT1_ORDRE INTEGER
  1719. CFG_SAUT2_ORDRE INTEGER
  1720. CFG_SAUT3_ORDRE INTEGER
  1721. CFG_SAUT4_ORDRE INTEGER
  1722. CFG_SAUT5_ORDRE INTEGER
  1723. TRAN_TOTAL BIT
  1724. SOLDEE_TOTAL BIT
  1725. SOM_STYLE INTEGER
  1726. RPVAL_GRAPH_LEGEND_STYLE INTEGER
  1727. CFG_PERF_COLOR INTEGER
  1728. TRAN_TOTAL_LIB VARCHAR(50)
  1729. SOLDEE_TOTAL_LIB VARCHAR(50)
  1730. MAIL_SUJET VARCHAR(300)
  1731. MAIL_BCC VARCHAR(100)
  1732. ID_PRO INTEGER AUTO_INCREMENT='2'
  1733. LIB_PRO VARCHAR(50)
  1734. ACTIVE BIT
  1735. ID_STYLE INTEGER
  1736. OP_PORTEFEUILLE BIT
  1737. SOLDEE_PRIX_ACHAT VARCHAR(50)
  1738. SOLDEE_PRIX_ACHAT_ORDRE INTEGER
  1739. OP_TTF VARCHAR(20)
  1740. OP_DIVERS4 BIT
  1741. OP_DIVERS5 BIT
  1742. PTF_LIG_DIVIDENDE VARCHAR(50)
  1743. PTF_LIG_DIVIDENDE_ORDRE INTEGER
  1744. ###TABLE_DATA_PREFERENCE_PRO
  1745. 0|0|0|0|2|2|1|2|3|4|6|7|8|9||0|0||0||0||0|LiquiditΘs|1|Titres en cours|2|Valorisation|3|Performance titres en cours|4|Performance|5|Apports|6|Retraits|7|Portefeuille|1|Au <--DATE_DEBUT--> (<--DEVISE-->)|2|Au <--DATE_FIN--> (<--DEVISE-->)|3|PΘriode (<--DEVISE-->)|4||0|0|1|Code|1|LibellΘ|2|QuantitΘ|3|Date achat|4|PRU|5|Date|6|Cours|7|Estimation|8|Perf. (<--DEVISE-->)|9|Perf. (%)|10||0|0|1|Code|1|LibellΘ|2|Total (<--DEVISE-->)|3|RΘpartition (%)|4||0|0|1|RΘpartition par valeur|0|600|270|0|0|Arial|8|Arial|8|0||0|0|1|Date|1|OpΘration|2|Montant (<--DEVISE-->)|3|Commentaire|4|1|1|1|1|1|1|1|1|1|1|1|1||0|0|1|Code|1|LibellΘ|2|QuantitΘ|3|Date achat|4|PRU|5|Date vente|6|Prix vente|7|Total vente|8|Perf. (<--DEVISE-->)|9|Perf. (%)|10||0||0||0|0|0|0|0|Sommaire|0|SynthΦse du portefeuille|Tableau des transactions en cours|Tableau de rΘpartition des transactions en cours|Graphique de rΘpartition des transactions en cours|Tableau des transactions soldΘes|Tableau des opΘrations sur portefeuille||||1|0|0|0|0|0|0|0|0|0|1|1|1|Total|Total|||1|Edition 1|1|1|0|Prix achat|0|1|1|1|Dividendes|8|
  1746. ###TABLE_STRUCT_CONTACT
  1747. ID_CONTACT INTEGER AUTO_INCREMENT='1'
  1748. ID_LIEN INTEGER
  1749. TYPE_CONTACT INTEGER
  1750. CIVILITE VARCHAR(50)
  1751. PRENOM VARCHAR(50)
  1752. NOM VARCHAR(50)
  1753. SOCIETE VARCHAR(50)
  1754. FONCTION VARCHAR(50)
  1755. FONCTION VARCHAR(50)
  1756. ADRESSE1 VARCHAR(200)
  1757. ADRESSE2 VARCHAR(200)
  1758. CODE_POSTAL VARCHAR(20)
  1759. VILLE VARCHAR(50)
  1760. TEL VARCHAR(50)
  1761. PORTABLE VARCHAR(50)
  1762. FAX VARCHAR(50)
  1763. EMAIL VARCHAR(50)
  1764. SITE_WEB VARCHAR(100)
  1765. COMMENT1 VARCHAR(100)
  1766. COMMENT2 VARCHAR(100)
  1767. COMMENT3 VARCHAR(100)
  1768. COMMENT4 VARCHAR(100)
  1769. COMMENT5 VARCHAR(100)
  1770. COMMENT6 VARCHAR(100)
  1771. COMMENT7 VARCHAR(100)
  1772. COMMENT8 VARCHAR(100)
  1773. PAYS VARCHAR(50)
  1774. PSEUDO VARCHAR(50)
  1775. PASSWORD VARCHAR(50)
  1776. RELEVE BIT
  1777. ID_CLIENT VARCHAR(20)
  1778. TYPE_LIEN INTEGER
  1779. CIVILITE2 VARCHAR(50)
  1780. PRENOM2 VARCHAR(50)
  1781. NOM2 VARCHAR(50)
  1782. RELATION12 VARCHAR(10)
  1783. ###TABLE_DATA_CONTACT
  1784. ###TABLE_STRUCT_STYLES
  1785. ID INTEGER AUTO_INCREMENT='2'
  1786. LIB VARCHAR(50)
  1787. FILE_CSS VARCHAR(250)
  1788. ###TABLE_DATA_STYLES
  1789. 1|Style 1||
  1790. ###TABLE_STRUCT_PREFERENCE_DOM
  1791. ID_DOM INTEGER AUTO_INCREMENT='2'
  1792. LIB_DOM VARCHAR(50)
  1793. ACTIVE BIT
  1794. ID_STYLE INTEGER
  1795. DOM_FRAIS_COLONNE INTEGER
  1796. DOM_DATE_START INTEGER
  1797. DOM_COURS BIT
  1798. DOM_PERF BIT
  1799. DOM_PERF_TYPE INTEGER
  1800. DOM_QUANTITE_TYPE INTEGER
  1801. DOM_DATE_ACHAT BIT
  1802. DOM_DATE_VENTE BIT
  1803. DOM_COURS_ACHAT BIT
  1804. DOM_TOTAL_ACHAT BIT
  1805. DOM_TOTAL_PRU BIT
  1806. DOM_COURS_VENTE BIT
  1807. DOM_TOTAL_VENTE BIT
  1808. DOM_INDICE_CODE VARCHAR(20)
  1809. DOM_PRU BIT
  1810. DOM_ORIGINE BIT
  1811. DOM_LOGO VARCHAR(255)
  1812. DOM_TITLE VARCHAR(1000)
  1813. DOM_HEAD VARCHAR(10000)
  1814. DOM_CENTER VARCHAR(10000)
  1815. DOM_FOOT VARCHAR(10000)
  1816. DOM_LIB_ACHAT VARCHAR(50)
  1817. DOM_LIB_VENTE VARCHAR(50)
  1818. DOM_LIB_FRAIS VARCHAR(50)
  1819. DOM_LIB_OBJ_LOSS VARCHAR(50)
  1820. DOM_LIB_PERF VARCHAR(50)
  1821. DOM_PERF BIT
  1822. DOM_OBJ_LOSS BIT
  1823. DOM_OP_AR BIT
  1824. DOM_OP_MASK BIT
  1825. DOM_OP BIT
  1826. DOM_TOTAL_PERF BIT
  1827. DOM_TOTAL_PERF_REF BIT
  1828. DOM_TOTAL_COURS BIT
  1829. DOM_LIQUIDITE BIT
  1830. DOM_VALORISATION BIT
  1831. DOM_FRAIS_SOUS_TOTAL BIT
  1832. DOM_FRAIS_LEGENDE BIT
  1833. DOM_FRAIS_LEGENDE_NO BIT
  1834. DOM_FRAIS_LEGENDE_UPDATE BIT
  1835. DOM_DIVIDENDE BIT
  1836. ###TABLE_DATA_PREFERENCE_DOM
  1837. 1|Edition 1|1|1|1|0|1|1|0|0|1|1|1|1|0|1|1|FR0003500008|0|1||<--PORTEFEUILLE--> AU <--DATE--><BR><--ETAT--><BR>DU <--DATE_DEBUT--> AU <--DATE_FIN-->||||Achat|Vente|Frais / OpΘrat.|Obj / Loss|Performance|1|0|1|0|1|1|0|1|1|1|0|0|0|0|0|
  1838. ###TABLE_STRUCT_RENFORT_PRU_NO
  1839. CODE VARCHAR(20)
  1840. ###TABLE_DATA_RENFORT_PRU_NO
  1841. ###TABLE_STRUCT_PHOTO
  1842. ID_PHOTO INTEGER AUTO_INCREMENT='2'
  1843. LIB_PHOTO VARCHAR(50)
  1844. ###TABLE_DATA_PHOTO
  1845. 1|Photo 1|
  1846. ###TABLE_STRUCT_TITRE
  1847. ID_TITRE INTEGER
  1848. LIB_TITRE VARCHAR(20)
  1849. ###TABLE_DATA_TITRE
  1850. ###TABLE_STRUCT_SECTOR
  1851. ID_SECTOR INTEGER AUTO_INCREMENT='41'
  1852. ID_CORRESPONDANCE VARCHAR(10)
  1853. LIB_SECTOR VARCHAR(70)
  1854. ###TABLE_DATA_SECTOR
  1855. 1|4|Mines|
  1856. 2|7|PΘtrole & gaz|
  1857. 3|11|Chimie|
  1858. 4|13|BΓtiment & MatΘriaux de construction|
  1859. 5|15|Sylviculture & Papiers|
  1860. 6|18|Acier & Autres mΘtaux|
  1861. 7|21|AΘrospatiale & DΘfense|
  1862. 8|24|Industries diversifiΘes|
  1863. 9|25|Equipements Θlectroniques & Electriques|
  1864. 10|26|Ingenierie & Biens d'Θquipement industriels|
  1865. 11|31|Automobiles & Equipementiers|
  1866. 12|34|Equipement mΘnager & Textiles|
  1867. 13|41|Boissons|
  1868. 14|43|Agro-alimentaire|
  1869. 15|44|SantΘ|
  1870. 16|47|HygiΦne, cosmΘtiques & Produits mΘnagers|
  1871. 17|48|Pharmacie & Biotechnologie|
  1872. 18|49|Tabac|
  1873. 19|52|DΘtaillants gΘnΘralistes|
  1874. 20|53|Loisirs & H⌠tels|
  1875. 21|54|MΘdias & Divertissements|
  1876. 22|58|Services supports|
  1877. 23|59|Transports|
  1878. 24|63|Distribution alimentation & Produits pharmaceutiques|
  1879. 25|67|Services de tΘlΘcommunications|
  1880. 26|72|ElectricitΘ|
  1881. 27|77|Autres services aux collectivitΘs|
  1882. 28|78|SΘcuritΘ des biens et des personnes|
  1883. 29|81|Banque|
  1884. 30|83|Assurance|
  1885. 31|84|Assurance vie|
  1886. 32|85|SociΘtΘs de portefeuille-holding|
  1887. 33|86|Immobilier|
  1888. 34|87|SpΘcialitΘs & Autres activitΘs financiΦres|
  1889. 35|89|Entreprises d'investissement|
  1890. 36|93|Equipements destinΘs aux technologies de l'information|
  1891. 37|97|Logiciels & Services informatiques|
  1892. 38|98|DiversifiΘ|
  1893. 39|91|Energie renouvelable|
  1894. 40|92|Recyclage|
  1895. ###TABLE_STRUCT_MARKET
  1896. ID_MARKET INTEGER AUTO_INCREMENT='36'
  1897. ID_CORRESPONDANCE VARCHAR(10)
  1898. LIB_MARKET VARCHAR(70)
  1899. IMPOT_BOURSE BIT
  1900. ACTION_FR BIT
  1901. OBLIGATION BIT
  1902. PLACE VARCHAR(5)
  1903. ###TABLE_DATA_MARKET
  1904. 1|ECA|Compartiment A|1|1|0|p|
  1905. 2|ECB|Compartiment B|1|1|0|p|
  1906. 3|ECC|Compartiment C|0|1|0|p|
  1907. 4|CS|Compartiment Special|1|1|0|p|
  1908. 5|ALT|Alternext|1|0|0|p|
  1909. 6|MLF|MarchΘ Libre Franτais|1|1|0|p|
  1910. 7|MLE|MarchΘ Libre Etrangers|1|0|0|p|
  1911. 8|EEZE|Zone euro|1|1|0|p|
  1912. 9|EEHZE|Hors zone euro|1|0|0|p|
  1913. 10|OPC1|OPCVM MonΘtaire|0|0|0|p|
  1914. 11|OPC2|OPCVM Obligataire|0|0|0|p|
  1915. 12|OPC3|OPCVM Actions|0|0|0|p|
  1916. 13|OPC4|OPCVM DiversifiΘs|0|0|0|p|
  1917. 14|OPC5|OPCVM Garantis|0|0|0|p|
  1918. 15|PARTI|Titres participatifs|0|0|0|p|
  1919. 16|OBL|Obligations|0|0|1|p|
  1920. 17|BS|Bons de souscription|0|0|0|p|
  1921. 18|SICAV|Sicavs|0|0|0|p|
  1922. 19|FCPI|FCPI / FIP|0|0|0|p|
  1923. 20|FOREX|Forex|0|0|0|p|
  1924. 21|FUTUR|Futures|0|0|0|p|
  1925. 22|CERT|Certificats|0|0|0|p|
  1926. 23|WAR|Warrants|0|0|0|p|
  1927. 24|TRAKE|Trackers|0|0|0|p|
  1928. 25|DJ|Dow Jones|0|0|0|u|
  1929. 26|NAS|Nasdaq|0|0|0|u|
  1930. 27|AEX|AEX|0|0|0|n|
  1931. 28|BEL|BEL|0|0|0|g|
  1932. 29|FTSE|FTSE|0|0|0|e|
  1933. 30|SMI|SMI|0|0|0|s|
  1934. 31|IBEX|IBEX|0|0|0|m|
  1935. 32|DAX|DAX|0|0|0|f|
  1936. 33|MIB|MIB|0|0|0|i|
  1937. 34|PSI|PSI|0|0|0|l|
  1938. 35|SP500|S&P 500|0|0|0|u|
  1939. ###TABLE_STRUCT_FISCALITE_TTF
  1940. YEAR_FISCALITE INTEGER
  1941. TAUX CURRENCY
  1942. ###TABLE_DATA_FISCALITE_TTF
  1943. 2012|0.2|
  1944. ###TABLE_STRUCT_VALEUR_TTF
  1945. CODE VARCHAR(20)
  1946. NOM VARCHAR(255)
  1947. DATE_DEBUT DATE
  1948. DATE_FIN DATE
  1949. ###TABLE_DATA_VALEUR_TTF
  1950. FR0000120404|Accor|2012/08/01|2099/12/31|
  1951. FR0010340141|Adp|2012/08/01|2099/12/31|
  1952. FR0000120073|Air Liquide|2012/08/01|2099/12/31|
  1953. FR0000031122|Air France - KLM|2012/08/01|2099/12/31|
  1954. FR0000130007|Alcatel-Lucent|2012/08/01|2099/12/31|
  1955. FR0010220475|Alstom|2012/08/01|2099/12/31|
  1956. FR0000033219|Altarea|2012/08/01|2099/12/31|
  1957. FR0006807004|APRR (AUTOROUTES PRR)|2012/08/01|2099/12/31|
  1958. FR0011027143|Areva|2012/08/01|2099/12/31|
  1959. FR0010313833|Arkema|2012/08/01|2099/12/31|
  1960. FR0000051732|Atos|2012/08/01|2099/12/31|
  1961. FR0000120628|Axa|2012/08/01|2099/12/31|
  1962. FR0000120966|Bic|2012/08/01|2099/12/31|
  1963. FR0010096479|Biomerieux|2012/08/01|2099/12/31|
  1964. FR0000131104|Bnp Paribas|2012/08/01|2099/12/31|
  1965. FR0000039299|Bollore|2012/08/01|2099/12/31|
  1966. FR0004548873|Bourbon|2012/08/01|2099/12/31|
  1967. FR0000120503|Bouygues|2012/08/01|2099/12/31|
  1968. FR0006174348|Bureau Veritas|2012/08/01|2099/12/31|
  1969. FR0000079659|Cambodge (Compagnie du)|2012/08/01|2099/12/31|
  1970. FR0000125338|Cap Gemini|2012/08/01|2099/12/31|
  1971. FR0000120172|Carrefour|2012/08/01|2099/12/31|
  1972. FR0000125585|Casino Guichard|2012/08/01|2099/12/31|
  1973. FR0000060501|Cfao|2012/08/01|2099/12/31|
  1974. FR0000120164|CGG Veritas|2012/08/01|2099/12/31|
  1975. FR0000130403|Christian Dior|2012/08/01|2099/12/31|
  1976. FR0005025004|CIC|2012/08/01|2099/12/31|
  1977. FR0000120982|Ciments Francais|2012/08/01|2099/12/31|
  1978. FR0000120222|Cnp Assurances|2012/08/01|2099/12/31|
  1979. FR0000121634|Colas|2012/08/01|2099/12/31|
  1980. FR0000045072|Credit Agricole|2012/08/01|2099/12/31|
  1981. FR0000120644|Danone|2012/08/01|2099/12/31|
  1982. FR0000121725|Dassault Aviation|2012/08/01|2099/12/31|
  1983. FR0000130650|Dassault Systemes|2012/08/01|2099/12/31|
  1984. FR0010908533|Edenred|2012/08/01|2099/12/31|
  1985. FR0010242511|EDF|2012/08/01|2099/12/31|
  1986. FR0000130452|Eiffage|2012/08/01|2099/12/31|
  1987. FR0000131757|Eramet|2012/08/01|2099/12/31|
  1988. FR0000121667|Essilor|2012/08/01|2099/12/31|
  1989. FR0004254035|Euler Hermes|2012/08/01|2099/12/31|
  1990. FR0000121121|Eurazeo|2012/08/01|2099/12/31|
  1991. FR0010221234|Eutelsat Com.|2012/08/01|2099/12/31|
  1992. FR0000121147|Faurecia|2012/08/01|2099/12/31|
  1993. FR0000030181|FDL|2012/08/01|2099/12/31|
  1994. FR0000062234|FinanciΦre Odet|2012/08/01|2099/12/31|
  1995. FR0000064578|Fonciere des Regions|2012/08/01|2099/12/31|
  1996. FR0000033409|Fonciere  Lyonnaise|2012/08/01|2099/12/31|
  1997. FR0000133308|France Telecom|2012/08/01|2099/12/31|
  1998. FR0000121857|Fromageries BEL|2012/08/01|2099/12/31|
  1999. FR0010208488|GDF Suez|2012/08/01|2099/12/31|
  2000. FR0010040865|Gecina Nom.|2012/08/01|2099/12/31|
  2001. FR0010533075|Groupe Eurotunnel|2012/08/01|2099/12/31|
  2002. FR0000121881|Havas|2012/08/01|2099/12/31|
  2003. FR0000052292|Hermes Intl|2012/08/01|2099/12/31|
  2004. FR0000035081|Icade|2012/08/01|2099/12/31|
  2005. FR0004035913|Iliad|2012/08/01|2099/12/31|
  2006. FR0000120859|Imerys|2012/08/01|2099/12/31|
  2007. FR0000125346|Ingenico|2012/08/01|2099/12/31|
  2008. FR0010259150|Ipsen|2012/08/01|2099/12/31|
  2009. FR0000077919|Jc Decaux Sa.|2012/08/01|2099/12/31|
  2010. FR0000121964|Klepierre|2012/08/01|2099/12/31|
  2011. FR0000120537|Lafarge|2012/08/01|2099/12/31|
  2012. FR0000130213|Lagardere|2012/08/01|2099/12/31|
  2013. FR0010307819|Legrand SA|2012/08/01|2099/12/31|
  2014. FR0000120321|L'oreal|2012/08/01|2099/12/31|
  2015. FR0000121014|Lvmh|2012/08/01|2099/12/31|
  2016. FR0000051070|Maurel Et Prom|2012/08/01|2099/12/31|
  2017. FR0010241638|Mercialys|2012/08/01|2099/12/31|
  2018. FR0000053225|Metropole Tv|2012/08/01|2099/12/31|
  2019. FR0000121261|Michelin|2012/08/01|2099/12/31|
  2020. FR0000120685|Natixis|2012/08/01|2099/12/31|
  2021. FR0000120560|Neopost|2012/08/01|2099/12/31|
  2022. FR0000044448|Nexans|2012/08/01|2099/12/31|
  2023. FR0000184798|Orpea|2012/08/01|2099/12/31|
  2024. FR0000120693|Pernod-Ricard|2012/08/01|2099/12/31|
  2025. FR0000121501|Peugeot|2012/08/01|2099/12/31|
  2026. FR0000121485|PPR|2012/08/01|2099/12/31|
  2027. FR0000130577|Publicis Groupe|2012/08/01|2099/12/31|
  2028. FR0000060618|Rallye|2012/08/01|2099/12/31|
  2029. FR0000130395|Remy Cointreau|2012/08/01|2099/12/31|
  2030. FR0000131906|Renault|2012/08/01|2099/12/31|
  2031. FR0010451203|Rexel|2012/08/01|2099/12/31|
  2032. FR0000121253|Rubis|2012/08/01|2099/12/31|
  2033. FR0000073272|Safran|2012/08/01|2099/12/31|
  2034. FR0000125007|Saint Gobain|2012/08/01|2099/12/31|
  2035. FR0000120578|Sanofi|2012/08/01|2099/12/31|
  2036. FR0010411983|Scor|2012/08/01|2099/12/31|
  2037. FR0000121972|Schneider Electric|2012/08/01|2099/12/31|
  2038. FR0000121709|Seb|2012/08/01|2099/12/31|
  2039. FR0000050916|Silic|2012/08/01|2099/12/31|
  2040. FR0000130809|Societe Generale|2012/08/01|2099/12/31|
  2041. FR0000121220|Sodexo|2012/08/01|2099/12/31|
  2042. FR0010613471|Suez Environnement|2012/08/01|2099/12/31|
  2043. FR0000121329|Thales|2012/08/01|2099/12/31|
  2044. FR0000131708|Technip|2012/08/01|2099/12/31|
  2045. FR0000054900|Tf1|2012/08/01|2099/12/31|
  2046. FR0000120271|Total|2012/08/01|2099/12/31|
  2047. FR0000124711|Unibail-Rodamco|2012/08/01|2099/12/31|
  2048. FR0000130338|Valeo|2012/08/01|2099/12/31|
  2049. FR0000120354|Vallourec|2012/08/01|2099/12/31|
  2050. FR0000124141|Veolia Environ.|2012/08/01|2099/12/31|
  2051. FR0000031775|Vicat|2012/08/01|2099/12/31|
  2052. FR0000052516|Vilmorin Cie|2012/08/01|2099/12/31|
  2053. FR0000125486|Vinci|2012/08/01|2099/12/31|
  2054. FR0000031577|Virbac|2012/08/01|2099/12/31|
  2055. FR0000127771|Vivendi|2012/08/01|2099/12/31|
  2056. FR0000121204|Wendel Invest.|2012/08/01|2099/12/31|
  2057. FR0000125684|Zodiac Aerospace|2012/08/01|2099/12/31|
  2058. FR0000071946|Alten|2014/01/01|2099/12/31|
  2059. FR0000034639|Altran Technologies|2014/01/01|2099/12/31|
  2060. FR0000076952|Artois Nom|2014/01/01|2099/12/31|
  2061. FR0000035164|BΘnΘteau|2014/01/01|2099/12/31|
  2062. FR0000061137|Burelle|2014/01/01|2099/12/31|
  2063. FR0000064784|FFP|2014/01/01|2099/12/31|
  2064. FR0000037947|Fimalac|2014/01/01|2099/12/31|
  2065. FR0000050353|Lisi|2014/01/01|2099/12/31|
  2066. FR0011594233|NumΘricΓble|2014/01/01|2099/12/31|
  2067. FR0000120495|Somfy SA|2014/01/01|2099/12/31|
  2068. FR0004188670|Tarkett|2014/01/01|2099/12/31|
  2069. FR0010918292|Technicolor|2014/01/01|2099/12/31|
  2070. FR0000054470|Ubisoft Entertainment|2014/01/01|2099/12/31|
  2071. FR0000054215|Unibel|2014/01/01|2099/12/31|
  2072. ###TABLE_STRUCT_SCREEN_TAILLE
  2073. ID_TAILLE INTEGER
  2074. ID_SCREEN_TAILLE VARCHAR(50)
  2075. SCREEN_TAILLE_WIDTH INTEGER
  2076. SCREEN_TAILLE_HEIGHT INTEGER
  2077. ###TABLE_DATA_SCREEN_TAILLE
  2078. ###TABLE_STRUCT_TAILLE
  2079. ID_TAILLE INTEGER AUTO_INCREMENT='2'
  2080. LIB_TAILLE VARCHAR(50)
  2081. ###TABLE_DATA_TAILLE
  2082. 1|Taille 1|
  2083. ###TABLE_STRUCT_FISCALITE_COMMUN
  2084. YEAR_FISCALITE INTEGER
  2085. PS_CSG CURRENCY
  2086. PF_IR CURRENCY
  2087. CSG_DEDUC CURRENCY
  2088. PNL CURRENCY
  2089. IR CURRENCY
  2090. ABATTEMENT CURRENCY
  2091. PER1_ABAT CURRENCY
  2092. PER2_ABAT CURRENCY
  2093. PER3_ABAT CURRENCY
  2094. PER1_PEA CURRENCY
  2095. PER2_PEA CURRENCY
  2096. PER3_PEA CURRENCY
  2097. PER4_PEA CURRENCY
  2098. PER4_ABAT CURRENCY
  2099. PER2_ABAT_YEAR INTEGER
  2100. PER3_ABAT_YEAR INTEGER
  2101. PER4_ABAT_YEAR INTEGER
  2102. PER2_PEA_YEAR INTEGER
  2103. PER3_PEA_YEAR INTEGER
  2104. PER4_PEA_YEAR INTEGER
  2105. ###TABLE_DATA_FISCALITE_COMMUN
  2106. 2014|15.5|24|5.1|21|30|40|0|50|65|22.5|19|0|0|0|2|8|0|2|5|8|
  2107. ###TABLE_STRUCT_TVA
  2108. TVA_CODE VARCHAR(10)
  2109. TVA_DATE DATE
  2110. TVA_TAUX CURRENCY
  2111. ###TABLE_DATA_TVA
  2112. FRANCE|1993/01/01|18.6|
  2113. FRANCE|1995/01/08|20.6|
  2114. FRANCE|2000/04/01|19.6|
  2115. FRANCE|2014/01/01|20|
  2116. EXO|1900/01/01|0|
  2117.